Microsoft T-SQL Performance Tuning Part 4: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server using SHOWPLAN Output and Analysis

Have you ever enabled the SHOWPLAN_TEXT option for a query only to find out you can`t understand the results? Ever wonder what the difference between a bookmark lookup and an index seek is? This white paper, authored by SQL Server expert Kevin Kline, discusses how to make the most of your tuning time by explaining all of the results returned by SHOWPLAN_TEXT and the Graphic SHOWPLAN tool.

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