SQL Server Execution Plans, Second Edition

SQL Server Execution Plans, Second Edition

This book focuses entirely on what SQL Server execution plans are, how to read them, and how to apply the information you learn from them in order to boost the performance of your SQL Servers.

Publication date: 01 Sep 2012

ISBN-10: n/a

ISBN-13: 9781906434922

Paperback: 322 pages

Views: 1,492

Type: Book

Publisher: Simple Talk Publishing

License: n/a

Post time: 02 Mar 2017 12:00:00

SQL Server Execution Plans, Second Edition

SQL Server Execution Plans, Second Edition This book focuses entirely on what SQL Server execution plans are, how to read them, and how to apply the information you learn from them in order to boost the performance of your SQL Servers.
Tag(s): Relational Database
Publication date: 01 Sep 2012
ISBN-10: n/a
ISBN-13: 9781906434922
Paperback: 322 pages
Views: 1,492
Document Type: Book
Publisher: Simple Talk Publishing
License: n/a
Post time: 02 Mar 2017 12:00:00
From the Introduction:
Grant Fritchey wrote:Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how SQL Server is executing your queries, including the points below. 

- Which indexes are getting used, and where no indexes are being used at all.
- How the data is being retrieved, and joined, from the tables defined in your query.
- How aggregations in GROUP BY queries are put together.
- The anticipated load, and the estimated cost, that all these operations place upon the system. 

All this information makes the execution plan a fairly important tool in the tool belt of database administrator, database developers, report writers, developers, and pretty much anyone who writes T-SQL to access data in a SQL Server database. 

Given the utility and importance of the tool, you'd think there'd be huge swathes of information devoted to this subject. To be sure, fantastic information is available from various sources, but there isn't one place to go for focused, practical information on how to use and interpret execution plans. 

This is where my book comes in. My goal was to gather into a single location as much useful information on execution plans as possible. I've tried to organize this information in such a way that it provides a clear route through the subject, right from the basics of capturing plans, through their interpretation, and then on to how to use them to understand how you might optimize your SQL queries, improve your indexing strategy, and so on.

More Resources:




About The Author(s)


Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Evangelist in January 2011.

Grant Fritchey

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Evangelist in January 2011.


Book Categories