Do you already wanted to know how SQL Server 2008 stores a database file physically on the hard drive? In this session you will learn the internal structure of a SQL Server 2008 database file, and how SQL Server stores tables and indices internally in the file system. Furthermore you will see the DBCC T-SQL command in action, with which you can analyze the internal storage format of your database files. All these information from this session helps you in your next database design to get out the last percent of performance from your new database solution.
Slide Deck 611 KB , MP4 Video Low 80 MB , Demo Code 9 KB , MP4 Video Med 114 MB , MP4 Video High 263 MB , MP4 Video HD 494 MB