What do you think?
Rate this book
SQL Server Execution Plans
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 your queries are being executed by SQL Server, - Which indexes are being used, and where no indexes are being used at all. - How the data is being retrieved, and joined, from the tables defi ned 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. Grant Fritchey's book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans. Sample chapters of the ebook have garnered stunning reviews, such "All I can say is WOW. This has to be the best reference I have ever seen on Execution Plans in SQL Server. My hats off to Grant Fritchey" Jonathan Kehayias.
250 pages, Paperback
First published March 1, 2008
21 people are currently reading
68 people want to read
About the author
Grant Fritchey
27Ìýbooks12ÌýfollowersI have over thirty years experience working in technical support, development and database administration. I'm work for Redgate Software as a Product Advocate. I am a Microsoft Data Platform MVP and AWS Community Builder. I write articles for publication at SQL Server Central and Simple-Talk. I present sessions at events, large and small, all around the world and online. I work with both SQL Server and PostgreSQL and have authored multiple books on a variety of topics related to databases and data management.
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 5 of 5 reviews
January 14, 2010
This book was an easy read on a subject that can be relatively intimidating for a developer with no experience in the area. It is a great introduction to learning how to read SQL Server Execution Plans. There are lots of good examples and screen shots describing how the server is interpreting the commands being executed.
However, one should note that the book is NOT about how the plans will help you to improve your queries. Instead, knowing how to read through the various execution plans will help the reader to understand where problems might exist.
However, one should note that the book is NOT about how the plans will help you to improve your queries. Instead, knowing how to read through the various execution plans will help the reader to understand where problems might exist.
December 27, 2016
A great and comprehensive book to learn in depth about the execution plans in SQL Server.
November 30, 2016
Yes, that's what this book is about - understanding execution plans. It starts with what happens when you execute a query where the author talks about the parser, algebraizer, the optimizer and the 'executor'!
If you're new to understanding the execution plan concepts, I'd suggest you take the first two chapters slowly and thoroughly. I did this and it helped me to read through the plans myself and I only skimmed over the paragraphs to confirm my knowledge.
This book doesn't tell you how to write better queries directly, but by enabling you to understand how the optimizer works, you'll end up writing better queries yourself.
The book does take you down some real advanced topics like cursors and parallelism. I don't think I'll use those tips for the most part of my work, but it was great to know them nevertheless.
If you're new to understanding the execution plan concepts, I'd suggest you take the first two chapters slowly and thoroughly. I did this and it helped me to read through the plans myself and I only skimmed over the paragraphs to confirm my knowledge.
This book doesn't tell you how to write better queries directly, but by enabling you to understand how the optimizer works, you'll end up writing better queries yourself.
The book does take you down some real advanced topics like cursors and parallelism. I don't think I'll use those tips for the most part of my work, but it was great to know them nevertheless.
December 20, 2014
A clear and concise book on how to read SQL Server Execution Plans and understand the different pieces involved. It has many great examples to illustrate plans generated by T-SQL in the text and shows how they change with various modifications. It's been awhile since I've read a technology book that was this well organized.
Read
August 3, 2015Location: ND6 IRC
Accession No: DL027411
Accession No: DL027411
Displaying 1 - 5 of 5 reviews
Can't find what you're looking for?
Get help and learn more about the design.