How to Think Like the SQL Server Engine
Speaker: Micah Gentry
February 8, 2017
When you pass in a query, how does SQL Server build the results? Time to role play: I will be an end user sending in queries, and you will play the part of the SQL Server engine. Using simple spreadsheets as your tables, you will 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.
Micah is a Database Manager for American Access Casualty Company and has been working with SQL Server for 15 years. He just loves SQL and wants to watch people be amazed by what SQL can do and how it can do it for them.