Execution Plans: What Can You Do With Them?
2015TL; DR
Learn how to use execution plans to understand how SQL Server works, not just tune your queries.
Session Details
People are aware that you can use an execution plan to tune a query, but do they have other uses? This session will drill down on all the hidden information within execution plans. The structures and information with an execution plan shows many of the inner workings of SQL Server. From calculated columns to referential integrity, these, and many other functions, are exposed through execution plans. From this session you’ll be able to better understand the inner workings of SQL Server as well as your own databases and queries.