Dissecting Execution Plans in SQL Server: A Primer

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.