Microsoft T-SQL Performance Tuning Part 1: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server using SET and DBCC

This white paper, authored by SQL Server expert Kevin Kline, discusses various performance tuning techniques that you can apply to your Microsoft SQL Server Transact-SQL programs in order to maximize SQL Server performance. You will learn various T-SQL discovery, optimization and tuning techniques using the SET and DBCC commands.

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/>.