How the SQL Server Engine Thinks
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 is a Microsoft Certified Master of SQL Server 2008 and a Microsoft SQL Server MVP. He has over a decade of experience with SQL Server, systems administration, SAN storage, virtualization, and project management. Today, he's a consultant for Brent Ozar Unlimited. Previously, Brent was a SQL Server expert at Quest Software and a DBA at Southern Wine & Spirits, a Miami-based wine and spirits distributor. Brent blogs at http://www.BrentOzar.com like it's going out of style.