Duration: 60 minutes
Track: Enterprise Database Administration & Deployment
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.
To access the session recording, please login or register first:
Not a PASS member? Click here to register.
Senior DBA, SurveyMonkey
Brandon is a senior DBA and veteran of IT in the healthcare industry. Originally starting out his career as a web developer, he quickly fell in love with SQL Server database development and... View More