SQL Server Execution Plans, Third Edition

SQL Server Execution Plans, Third 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: 04 Oct 2018

ISBN-10: n/a

ISBN-13: 9781910035221

Paperback: 515 pages

Views: 9,611

Type: Book

Publisher: Simple Talk Publishing

License: n/a

Post time: 02 Mar 2017 01:00:00

SQL Server Execution Plans, Third Edition

SQL Server Execution Plans, Third 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: 04 Oct 2018
ISBN-10: n/a
ISBN-13: 9781910035221
Paperback: 515 pages
Views: 9,611
Document Type: Book
Publisher: Simple Talk Publishing
License: n/a
Post time: 02 Mar 2017 01: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 Data Platform MVP with over 30 years' experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. Grant volunteers for PASS and is on the Board of Directors as the Immediate Past President. He joined Redgate Software as a product advocate January 2011.

Grant Fritchey

Grant Fritchey is a Data Platform MVP with over 30 years' experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. Grant volunteers for PASS and is on the Board of Directors as the Immediate Past President. He joined Redgate Software as a product advocate January 2011.


Book Categories
Sponsors