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.
Presented by Brent Ozar at SQLBits XII
Tags (no tags)
  • Downloads
    Video available MP4 Video HD 482 MB
  • SpeakerBIO
    Brent_Ozar.png
    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.
    https://www.brentozar.com/ https://www.brentozar.com/feed/
  • Video