Microsoft T-SQL Performance Tuning Part 3: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server using Query Optimizer Strategies

This white paper, authored by SQL Server expert Kevin Kline, discusses a number of Query Optimizer strategies to improve performance in your SQL Server queries. This white paper will focus on topics such as: sub-query optimization, UNION vs. UNION ALL, SELECT INTO vs. INSERT...SELECT, parameters vs. variables in stored procedures, and much more.

Material adapted from `Transact-SQL Programming` (O`Reilly & Associates, ISBN: 1565924010) by Kevin Kline, Lee Gould, and Andrew Zanevsky, <http://www.oreilly.com/catalog/wintrnssql/>.