Platinum Sponsor

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 specializes in making SQL Server faster and more reliable.   He's a Microsoft Certified Master of SQL Server and MVP, and he has over a decade of experience.  He coauthored Professional SQL Server 2008 Internals and Troubleshooting, created sp_Blitz™ and sp_AskBrent™, and he loves sharing knowledge at BrentOzar.com.
    http://www.brentozar.com/ http://feeds2.feedburner.com/BrentOzar-SqlServerDba
  • Video