If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.

I wrote this book with the singular goal of teaching you how to read SQL Server Execution plans

It will explain, among many other things, the following:

How to capture execution plans using manual and automatic methods
A documented method for reading and interpreting execution plans
How common SQL Server objects, such as indexes, views, stored procedures, and so on, appear in execution plans
How to control execution plans with hints and plan guides, and why this is a double-edged sword
How the Query Store works with, and collects data on, execution plans

With this knowledge, you'll have everything you need to read the execution plan, for any query of your own, regardless of complexity, and understand what it does and what is causing the bad performance. It is still your job to work out how best to fix it, but your new understanding of execution plans will give a much better chance of success!

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Seller's business information

Schwabe Books, Inc. DBA Books From California
51 W. Easy St., Simi Valley, CA, 93065, U.S.A.

Sale & Shipping Terms

Terms of Sale

Refunds Offered Within 10 days of order.

Greg Schwabe
Books From California
51 W. Easy St
Simi Valley, CA. 93065

Fax # 805-582-9513
For questions, please email at
abesales@booksfromca.com

Shipping Terms

Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	5 to 14 business days	3 to 6 business days
First item	US$ 4.99	US$ 6.95

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.