Dissecting SQL Server Execution Plans

Dissecting SQL Server Execution Plans

Paperback

By (author) Grant Fritchey, Edited by Tony Davis

$22.84
List price $31.23
You save $8.39 26% off

Free delivery worldwide
Available
Dispatched in 4 business days
When will my order arrive?

  • Publisher: Simple Talk Publishing
  • Format: Paperback | 250 pages
  • Dimensions: 156mm x 234mm x 13mm | 356g
  • Publication date: 24 March 2009
  • Publication City/Country: Cambridge
  • ISBN 10: 1906434026
  • ISBN 13: 9781906434021
  • Illustrations note: black & white illustrations
  • Sales rank: 287,917

Product description

Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defi ned in your query. How aggregations in GROUP BY queries are put together. The anticipated load and the estimated cost that all these operations place upon the system. Grant Fritchey's book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans. Sample chapters of the ebook have garnered stunning reviews, such as: "All I can say is WOW. This has to be the best reference I have ever seen on Execution Plans in SQL Server. My hats off to Grant Fritchey" Jonathan Kehayias.

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 11 of 11