Dissecting SQL Server Execution Plans by Grant Fritchey

Dissecting SQL Server Execution Plans by Grant Fritchey

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.

Grant Fritchey, Microsoft Data Platform MVP, has more than 20 years of experience in IT. That time was spent in technical support, development, and database administration. He currently works as Product Evangelist at Red Gate Software. Grant writes articles for publication at SQL Server Central and Simple-Talk. He has published books, including SQL Server Execution Plans and SQL Server 2012 Query Performance Tuning (Apress). He has written chapters for Beginning SQL Server 2012 Administration (Apress), SQL Server Team-based Development, SQL Server MVP Deep Dives Volume 2, Pro SQL Server 2012 Practices (Apress), and Expert Performance Indexing in SQL Server (Apress). Grant currently serves as President on the Board of Directors of the PASS organization, the leading source of educational content and training on the Microsoft Data Platform.

SKU	Unavailable
ISBN 13	9781906434021
ISBN 10	1906434026
Title	Dissecting SQL Server Execution Plans
Author	Grant Fritchey
Condition	Unavailable
Binding Type	Paperback
Publisher	Simple Talk Publishing
Year published	2008-03-01
Number of pages	250
Cover note	Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
Note	Unavailable