Industrial-Sized Deals Shop all Back to School Shop Women's Handbags Learn more nav_sap_SWP_6M_fly_beacon Beach House $5 Off Fire TV Stick Subscribe & Save Shop Popular Services pivdl pivdl pivdl  Amazon Echo Starting at $99 Kindle Voyage Nintendo Digital Games Gear Up for Football STEM Toys & Games
Qty:1
  • List Price: $29.99
  • Save: $4.36 (15%)
FREE Shipping on orders over $35.
In stock but may require an extra 1-2 days to process.
Ships from and sold by Amazon.com.
Gift-wrap available.
SQL Server Execution Plan... has been added to your Cart
Condition: Used: Like New
Comment: Eligible for FREE Super Saving Shipping! Fast Amazon shipping plus a hassle free return policy mean your satisfaction is guaranteed! Tracking number provided in your Amazon account with every order. Crisp, clean pages; like new.
Sell yours for a Gift Card
We'll buy it for $2.00
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Server Execution Plans Paperback – March 24, 2009

7 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price New from Used from
Paperback
"Please retry"
$25.63
$13.98 $13.87
$25.63 FREE Shipping on orders over $35. In stock but may require an extra 1-2 days to process. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

SQL Server Execution Plans + Inside the SQL Server Query Optimizer
Price for both: $49.67

One of these items ships sooner than the other.

Buy the selected items together

NO_CONTENT_IN_FEATURE

Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Paperback: 250 pages
  • Publisher: Simple Talk Publishing (March 24, 2009)
  • Language: English
  • ISBN-10: 1906434026
  • ISBN-13: 978-1906434021
  • Product Dimensions: 6.1 x 0.5 x 9.2 inches
  • Shipping Weight: 9.1 ounces (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (7 customer reviews)
  • Amazon Best Sellers Rank: #1,161,355 in Books (See Top 100 in Books)

Customer Reviews

5 star
43%
4 star
57%
3 star
0%
2 star
0%
1 star
0%
See all 7 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

15 of 15 people found the following review helpful By David Martin on September 11, 2009
Format: Paperback Verified Purchase
If you are one of those people (like me) who wonder why Sql Server does certain things (like ignoring your well-planned-out index), or if your professional pride requires that you deploy sql code which other professionals cannot laugh at, then you *must* understand the basic details of the SS Query Optimizer.
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 ›
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By Eric Wisdahl on January 14, 2010
Format: Paperback Verified Purchase
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By AJ Phillips on September 19, 2010
Format: Paperback Verified Purchase
I have to start out by saying...finally! As a .NET developer, I am always personally interested in stretching my limits and perfecting my craft. Although there may be a handful of applications that don't require data access, I've never witnessed any that weren't trivial. I work with SQL Server professionally and personally. I've looked at execution plans for a little while and when I really paid attention to them (in SQL 2005), I couldn't believe the potential for correcting bad mistakes. The trouble came when I couldn't find any texts on SQL Server that really made more than a passing reference to execution plans. I set out anew to find something definitive and the timing was right.

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 ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Jeremy N. Carter on January 27, 2010
Format: Paperback Verified Purchase
Every dba should have a copy of this. It is a fantastic resource for those deep dive analysis of the query execution plans. I have not see anything else that goes into such detail to explain just how sql is actually getting your data.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
SQL Server Execution Plans
This item: SQL Server Execution Plans
Price: $25.63
Ships from and sold by Amazon.com

Want to discover more products? Check out this page to see more: programming languages