Start reading SQL Server Execution Plans on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Colour:
Image not available
 

SQL Server Execution Plans [Kindle Edition]

Grant Fritchey

Print List Price: £19.99
Kindle Price: £7.91 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £12.08 (60%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £7.91  
Paperback £19.98  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others?

My response is the same in each case: have you looked at the execution plan? An execution plan describes what's going on behind the scenes when SQL Server executes a query. It shows how the query optimizer joined the data from the various tables defined in the query, which indexes it used, if any, how it performed any aggregations or sorting, and much more. It also estimates the cost of all of these operations, in terms of the relative load placed on the system. Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans.

SQL Server Execution Plans leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

Customers Who Bought This Item Also Bought

Page of Start over
This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Product details

  • Format: Kindle Edition
  • File Size: 4469 KB
  • Print Length: 346 pages
  • Publisher: Red Gate Books; 2 edition (21 May 2013)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00CXWRFQA
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Not Enabled
  • Amazon Bestsellers Rank: #459,014 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Author

Discover books, learn about writers, and more.

Customer Reviews

There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.8 out of 5 stars  4 reviews
5.0 out of 5 stars SQL Server Execution Plans 20 July 2014
By Gary Clausen - Published on Amazon.com
Format:Paperback|Verified Purchase
Very good book!! Very helpful in my current job as a DBA. The experience with Amazon was great, delivered fast.
5.0 out of 5 stars Five Stars 26 July 2015
By Jamie Salza - Published on Amazon.com
Format:Paperback|Verified Purchase
Very informative and well written.
4.0 out of 5 stars Four Stars 7 Dec. 2014
By Bruce Blachford - Published on Amazon.com
Format:Paperback|Verified Purchase
Good overall review yeah
5.0 out of 5 stars Five Stars 16 Aug. 2014
By Amazon Customer - Published on Amazon.com
Format:Kindle Edition|Verified Purchase
Excellent book!!!
Were these reviews helpful?   Let us know

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