SQL Server Execution Plans (Paperback)
SQL Server Execution Plans (Paperback)
Hero image 0 of SQL Server Execution Plans (Paperback), 0 of 1

SQL Server Execution Plans (Paperback)

(No ratings yet)

Key item features

SQL Server Execution Plans (Paperback)

Specs

Publication date, October, 2012Author, Grant FritcheyBook format, PaperbackGenre, Computing & InternetPages, 344Age group, Adult

About this item

Product details

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. My book 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.
SQL Server Execution Plans (Paperback)
info:
We aim to show you accurate product information. Manufacturers, suppliers and others provide what you see here, and we have not verified it.  

Specifications

Publication date

October, 2012

Author

Grant Fritchey

Book format

Paperback

Genre

Computing & Internet

Warranty

Warranty information

Please be aware that the warranty terms on items offered for sale by third party Marketplace sellers may differ from those displayed in this section (if any). To confirm warranty terms on an item offered for sale by a third party Marketplace seller, please use the 'Contact seller' feature on the third party Marketplace seller's information page and request the item's warranty terms prior to purchase.

Customer ratings & reviews

0 out of 5 stars
0 ratings|0 reviews
This item does not have any reviews yet
Current price is $20.38
Price when purchased online
  • Free 90-day returns

How do you want your item?

Try 30 days for just $1! Choose a plan at checkout.
How do you want your item?
Ships to
Arrives by Fri, Nov 27
Sold and shipped by Walmart.com
Free 90-day returns
This item is gift eligible

More seller options (3)

Starting from $25.71
walmart plus

Try 30 days of Walmart+ for just $1!

T&C apply.