Industrial-Sized Deals Shop all Back to School Shop Women's Handbags Learn more nav_sap_plcc_6M_fly_beacon $5 Albums $5 Off Fire TV Stick Off to College Essentials Shop Popular Services pivdl pivdl pivdl  Amazon Echo Starting at $99 Kindle Voyage Nintendo Digital Games Shop Back to School with Amazon Back to School with Amazon Outdoor Recreation STEM Toys & Games
Inside the SQL Server Query Optimizer and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $29.99
  • Save: $5.95 (20%)
FREE Shipping on orders over $35.
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Inside the SQL Server Que... has been added to your Cart
+ $3.99 shipping
Condition: Used: Very Good
Comment: Your purchase benefits the Santa Clara City Library. THANK YOU FOR YOUR SUPPORT!
Sell yours for a Gift Card
We'll buy it for $4.70
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

Inside the SQL Server Query Optimizer Paperback – March 7, 2011

9 customer reviews

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$24.04
$19.05 $13.41
$24.04 FREE Shipping on orders over $35. Only 1 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

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

Buy the selected items together

If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle Edition for FREE. Print edition purchase must be sold by Amazon. Learn more.


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: 272 pages
  • Publisher: Red Gate books (March 7, 2011)
  • Language: English
  • ISBN-10: 1906434603
  • ISBN-13: 978-1906434601
  • Product Dimensions: 7.5 x 0.6 x 9.2 inches
  • Shipping Weight: 1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #1,341,585 in Books (See Top 100 in Books)

More About the Author

Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of "SQL Server 2014 Query Tuning & Optimization" and "Inside the SQL Server Query Optimizer" and co-author of "SQL Server 2012 Internals". With more than 20 years of experience in relational databases, Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits. Benjamin's blog can be found at http://www.benjaminnevarez.com and he can also be reached by e-mail at admin at benjaminnevarez dot com and on twitter at @BenjaminNevarez.

Customer Reviews

5 star
89%
4 star
0%
3 star
0%
2 star
11%
1 star
0%
See all 9 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

5 of 5 people found the following review helpful By Mark Broadbent on August 19, 2011
Format: Paperback
There are only a handful of people that when they talk about something you should sit up and take notice, and for me Benjamin Nevarez is one of those. As someone I've been following technically for several years, when I saw that his book "Inside the SQL Server Query Optimizer" had been released to the Kindle format, I immediately clicked the purchase button and I haven't been disappointed.

What is particularly obvious upon reading is that Benjamin is not only a subject matter expert on SQL Server Query Optimizer and Query Optimization, but is passionate and enthusiastic about it which translates directly onto the pages, making for a very enjoyable experience. Probably the biggest way in which this book differs from similar efforts by other experts in this area is the way in which it takes an inside-out approach to this subject rather than an outside-in approach and for me this methodology works really really well.

If you can, try to imagine Query Optimization as being a bit like layers of an Onion with the Optimizer itself sitting firmly in the centre. When reading other books on the subject I have found myself getting quite frustrated as they slowly peel off each layer and never really seem to hit the centre. This always makes me feel as though I didn't really know what happened behind the scenes (even if I understood the why). This book is different and Benjamin takes this metaphorical Onion and slices it in two revealing what lies in the centre and slowly building onto it bit by bit.
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
2 of 2 people found the following review helpful By A. Zubarev on October 2, 2011
Format: Paperback
Firstly, two thumbs up for the "to the point" content of the book.
Even though it took a while for me to read this book, or rather I should say 'comprehend' it, the book felt not too long and not too short, I realized the content is just adequate/right to a more than a beginner in SQL Server, but I just wanted to experiment in my test environment in addition to what was in the book, as the end result today I have 11 queries optimized to save my customers total of 4 hours plus of wasted CPU time!
Secondly, there are so few books around on the "mysterious" Query Optimizer, to most consultants in my practice it was always intimidating to even think of trying to figure out what is going "behind the scenes", I guess this should not be anymore the case.
In short, do you want to learn on the most complicated and advanced topic from a 15 year veteran in SQL Server for a fraction of the cost of any class? You bet!
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
2 of 2 people found the following review helpful By Simon on July 20, 2012
Format: Paperback
There are many books out there on SQL Server. The problem is once you've reached a certain level of expertise in SQL Server there is very little extra to learn from most of them.

'Inside the SQL Server Query Optimizer' was very different. The author dives into the guts of the optimizer and shows how it produces query plans using indexes, statistics and a whole host of other factors to determine the best likely operators. He also does a fantastic job of tying the concepts back to actual queries and execution plans that you can reproduce in SQL Server Management studio. I found the book lucidly written and the new insights I gained from it immensely useful for optimizing my databases and queries.

If you know something about SQL Server, I highly recommended to get you to the next level!
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
2 of 2 people found the following review helpful By Justin on August 16, 2011
Format: Paperback Verified Purchase
After hearing about this book several months before its release, I waited eagerly for it and was not disappointed once I finally got to read it. I've worked with SQL Server for about three years and am constantly learning and discovering new things. The query optimizer was one of those things that both fascinated and perplexed me, as it can be overwhelming to look at an execution plan and figure exactly what it's doing let alone why the optimizer chose to use it. Benjamin Nevarez's "Inside the SQL Server Optimizer" is a great tool for anyone interested in understanding what happens under the hood when you execute a query. In my opinion, it's a must have for any serious SQL developer or DBA.
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
1 of 1 people found the following review helpful By kchant1975 on August 16, 2011
Format: Paperback
If you're into SQL then this is a very good book if you want to know how the Optimizer works for SQL Server 2008, it's the best break down I've read on how the Optimizer operates, and also has quiet a few handy examples which will encourage you to challenge your databases.
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
Inside the SQL Server Query Optimizer
This item: Inside the SQL Server Query Optimizer
Price: $24.04
Ships from and sold by Amazon.com

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