Home » Blog » Presentation Materials – Index Internals

Presentation Materials – Index Internals

2012-01-22 - Presentations

Abstract

In this session we will examine one of SQL Servers' most fundamental yet most important functions - how does SQL Server store data on disk and how does it find it again when executing a query. Using a combination of demos, lecture and discussions we will begin with the structure of the data on disk by delving into the world of HoBTs and Extends, RIDs and Keys and especially Pages. From there we will tackle topics concerning the retrieval of data such as Index levels, Index Scans and Seeks and Lookups.

Downloads

• Slides
• TableInfo & IndexInfo

Other Resources

• SQL Sentry Plan Explorer
• Microsoft® SQL Server® 2008 Internals (Pro - Developer)

Categories: Presentations