Dissecting SQL Server Execution Plans

Fritchey, Grant

ISBN 10: 1906434026 / ISBN 13: 9781906434021

Verlag: Simple Talk Publishing, 2009

The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Bestandsnummer des Verkäufers GOR006506584

Inhaltsangabe:

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.

Reseña del editor: 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.

Bibliografische Details

Titel: Dissecting SQL Server Execution Plans
Verlag: Simple Talk Publishing
Erscheinungsdatum: 2009
Einband: Paperback
Zustand: Very Good