Optimizing Slow Queries Due to Sub-Select Issues in SQL

How to Run Windows Commands Under SQL Queries Using xp_cmdshell in Microsoft SQL Server