Dissecting SQL Server Execution Plans (Free eBook)
Have you ever wished you have a compact source or reference that will help you understand the Execution Plans in SQL Server better? Are you a junior DBA that is lost in trying to understand why your queries are very slow to execute? The master DBA told you “hey, check your indexes”; but then you do not know where to start.
You are right. This post is ready to answer those questions. Well, I wish I have the technical know-how to do just that. But, no. I am not yet on that level. Not even close.
How about some eBook. How is that. No you do not have to pay for it. Hell, yes. It’s free.
Here are some questions that will be answered by the book (quoted from the site)
Why is this query running slow? Is my index getting used? Why does this query run faster than this query? Well, have you even looked at the execution plan?