Data Pages, Allocation Units, IAM chains... Oh My!

Brandon Leach
60 minutes
Enterprise Database Administration & Deployment
DBA, Architect, Developer
Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions. We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.
Intermediate database design..

View Recording

To access the session recording, please login or register first:

Sign In

Not a PASS member? Click here to register.