Inside the SQL Server Query Optimizer and over 2 million other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
Trade in Yours
For a 2.43 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading Inside the SQL Server Query Optimizer on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Inside the SQL Server Query Optimizer [Paperback]

Benjamin Nevarez
5.0 out of 5 stars  See all reviews (1 customer review)
RRP: 19.99
Price: 15.99 & FREE Delivery in the UK. Details
You Save: 4.00 (20%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 3 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Tuesday, 22 April? Choose Express delivery at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition 9.40  
Paperback 15.99  
Trade In this Item for up to 2.43
Trade in Inside the SQL Server Query Optimizer for an Amazon.co.uk gift card of up to 2.43, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

7 Mar 2011 1906434603 978-1906434601
The SQL Server Query Optimizer is perceived by many to be a magic black box, transforming SQL queries into high performance execution plans in the blink of an eye through some unknowable process. The truth is that, while the Query Optimizer is indeed the highly-complex result of decades of research, learning how it works its magic is not only possible, but immensely useful to DBAs and Developers alike. A better understanding of what the Query Optimizer does behind the scenes can help you to improve the performance of your databases and applications, and this book explains the core concepts behind how the SQL Server Query Optimizer works. With this knowledge, you'll be able to write superior queries, provide the Query Optimizer with all the information it needs to produce efficient execution plans, and troubleshoot the cases when the Query Optimizer is not giving you the best plan possible. With over 15 years of experience in the use of Relational Databases (including SQL Server since version 6.5), Benjamin has watched the SQL Server Query Optimizer grow and evolve. His insight will leave you with an excellent foundation in the practicalities of the Query Optimizer, and everything you need to know to start tuning your queries to perfection.

Frequently Bought Together

Inside the SQL Server Query Optimizer + Mastering SQL Server Profiler + Performance Tuning with SQL Server Dynamic Management Views (High Performance SQL Server)
Price For All Three: 50.53

Buy the selected items together


Product details

  • Paperback: 272 pages
  • Publisher: Red gate books (7 Mar 2011)
  • Language: English
  • ISBN-10: 1906434603
  • ISBN-13: 978-1906434601
  • Product Dimensions: 1.4 x 18.8 x 23.1 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 559,930 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
4 of 5 people found the following review helpful
5.0 out of 5 stars In-depth guide 20 Jun 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?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.6 out of 5 stars  7 reviews
3 of 3 people found the following review helpful
5.0 out of 5 stars An essential purchase for your SQL Server library 19 Aug 2011
By Mark Broadbent - Published on Amazon.com
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.

What I really like most about "Inside the SQL Server Query Optimizer" is the fact that it is not just a revealing read but a very practical guide to Optimization for the reader and demonstrates optimization with lots of pictures of example queries, query plans, statistics and estimations. What this means is that even if you are a relative beginner at Query Optimization this book will be readily accessible to you. Expert readers also have much to learn from its pages since the book pretty much covers everything you need to know about the Query Optimizer and Optimization.

One thing I particularly like is the fact that this book even talks about Optimizing Data Warehouse workloads and manages to keep the discussion at a level that is not only informative but understandable, and this is no small feat. I also love all those little tricks and tips provided throughout the book such as "right-click anywhere on the execution plan window to display a pop-up window and select Show Execution Plan XML..." as a way to quickly change your query plan into XML format -which can be very useful for third party tools such as SQLSentry's Plan Explorer. As somebody who infrequently has to look into Optimization these kind of tips are invaluable and leave you wondering how you'd missed them in the first place!

My only criticism I have that with this book is that Benjamin has left me wanting more from him! I therefore look forward to seeing further efforts from him and recommend that you add this to your own personal library without delay making it an essential purchase.
2 of 2 people found the following review helpful
5.0 out of 5 stars Take your SQL Server knowledge to the next level 20 July 2012
By Simon - Published on Amazon.com
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!
2 of 2 people found the following review helpful
5.0 out of 5 stars A must have for anyone who works with SQL Server! 3 Oct 2011
By A. Zubarev - Published on Amazon.com
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!
2 of 2 people found the following review helpful
5.0 out of 5 stars A peek into the mind of the optimizer 16 Aug 2011
By Justin - Published on Amazon.com
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.
1 of 1 people found the following review helpful
5.0 out of 5 stars Very good book 16 Aug 2011
By kchant1975 - Published on Amazon.com
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.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews
ARRAY(0xa3948cc0)

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback