SQL Server Execution Plans
by Grant Fritchey
Publisher: Simple Talk Publishing 2012
ISBN/ASIN: 190643493X
Number of pages: 332
Description:
An execution plan describes what’s going on behind the scenes when SQL Server executes a query. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.