November 14, 2013 · 6:00 PM
SQL Server Index Internals
Summary: Have you ever wondered what an index actually looks like and performs under the covers? In this talk I'll discuss Index Internals, and how SQL Server creates, maintains, and uses indexes internally for normal operations. I’ll be discussing topics such as index data structures, query optimization (briefly) and maintaining indexes and statistics.
Speaker: Tim Chapman, Dedicated Premier Field Engineer Microsoft
Tim Chapman is a Microsoft Certified Master (MCM) and works as a Dedicated Support Engineer (PFE) at Microsoft, specializing in performance tuning and high availability. Before coming to Microsoft, Tim was a contributor to the SQL MVP community for 3 years. Tim has over 12 years of database architecture, programming, and administration experience.