Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your email address or mobile phone number.
SQL Server Execution Plans Paperback – March 24, 2009
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Frequently Bought Together
Customers Who Bought This Item Also Bought
Top Customer Reviews
This book is thin, omits all of the traditional 'fluff' abstractions, and delivers the details through 'work-along-side-me' examples. The author is not-so-much writing a book as training a 'junior' administrator on how to understand queries and their execution. It is a streamlined training session on one specific topic, and can be consumed (and digested) in a few sit-down sessions.
The level of detail is much finer than any introductory book on Sql administration (or programming), but does not try to match the atomicity of Delaney's "Inside Microsoft Sql Server 2005" series. (Delaney's books are excellent academic achievements which will make you dizzy, lightheaded (possibly nauseous) at the first reading.)
I read Fritchey's book on a Friday evening, and spent the weekend working the examples on my own system. By Monday I was comfortable with troubleshooting many weak t-sql queries at the office, and it gave me the experience I needed to start practicing on creating 'useful' indexes.
This book gives a very good explanation on the topic of 'selectivity', which is the single most important principle of indexing in Sql Server.
The book is a good way to 'get your feet wet' with using Sql Profiler (rather than waiting until serious issues require you to learn on-the-job).
The book is a required follow-up book to the 70-444 (Self Based Training Kit) for Sql Server 2005 DBA certification.Read more ›
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.
Mr. Fritchey's work has demystified so many of the fine points of why SQL Server develops one plan over another. There were more than a few operators that I didn't fully grasp and this reference has finally shed light on those operators. If you've ever wondered what those plans were all about then this text will explain in detail each operator in sample plans generated from sample queries, both simple and complex. Don't worry that you'll dive right into complex selections that look as if they are part of a disgruntled programmer's plot of obfuscation. Mr. Fritchey has chosen to sensibly start with simple queries and explains the plan results. Then he moves into slight query modifications and explains how and why the new plan differs. Eventually, query selections grow in complexity one layer at a time and the plan explanations keep right up in a logical manner. You'll be able to see the results for yourself in the book but I recommend performing the same SQL queries on your own instance to get the best view.Read more ›
Most Recent Customer Reviews
It is well written, and explain clearly what you need to know (the semantics) of the symbols and icons which appear in the graphic execution plans. Read morePublished 23 months ago by Gabe
Well, since this isn't a riviting novel or novella, It is adequate for what I needed. Shipped in a timely fashion and I had no problems with the purchase.Published on November 1, 2010 by Finderonline