SQL Server Execution Plans: Third Edition

by Grant Fritchey

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
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!

520 pages, Paperback

Published October 1, 2018

About the author

I have over thirty years experience working in technical support, development and database administration. I'm work for Redgate Software as a Product Advocate. I am a Microsoft Data Platform MVP and AWS Community Builder. I write articles for publication at SQL Server Central and Simple-Talk. I present sessions at events, large and small, all around the world and online. I work with both SQL Server and PostgreSQL and have authored multiple books on a variety of topics related to databases and data management.

Reviews

[Asiful Nobel · Rating 3 out of 5]

I have not read the whole book. I read only the chapters that were needed for me to learn how to read the execution plan of a T-SQL query. After reading those chapters, I must say that this book contains some detailed information with examples that I was not able to find in official Microsoft documentation.

It is worth a read if someone is looking to understand how SQL Server actually executes a query and how to tune queries for optimized performance based on this information. But reading this from start to finish may not be worthwhile for a Software Engineer.

[Mahdi Khalil Nejad · Rating 5 out of 5]

اولین خوبی کتاب که باید تمام کتاب‌های دیتابیس داشته باشن رو داره که اونم
اینه که دیتابیس معرفی میکنه و تا آخر کتاب با اون دیتا بیس میره جلو مباحث رو

بعد از اینکه خوب به کوئری نویسی مسلط شدید
این یکی از بهترین کتاب‌هایی که میتونید مطالعه کنید
خیلی مباحث زیادی پوشش میده و خیلی هم کش نمیده و خسته کننده نمیشه

البته یه اشکالی که داره اینه (البته به خود کتاب مربوط نمیشه) که
اسکریپتی که تو گیت‌هاب معرفی کرده یکم قدیمه و آپدیت نیاز داره که با مطالب کتاب هماهنگ بشه

[fhrnko · Rating 5 out of 5]

Deep dive to query plan. I learned many new things