How the SQL Server Engine Thinks
When you pass in a query, how does SQL Server build the results? We'll role play: Brent Ozar will be an end user sending in queries, and you'll be the SQL Server engine. Using simple spreadsheets as your tables, you'll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability.
Brent Ozar makes SQL Server faster and more reliable. He's a Microsoft Certified Master of SQL Server, and he created sp_Blitz®, DBAreactions.com, SQLServerUpdates.com, and GroupBy.org.