Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slo

An execution plan describes what's going on behind the scenes when SQL Server executes a query. It shows how the query optimizer joined the data from the variou

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 execut

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 wh