On-Disk Data Structures in SQL Server

<< Toronto and Area User Groups of Interest | Instant Initialization for SQL Server >>

On-Disk Data Structures in SQL Server

by Steve Syfuhs / November 16, 2008 04:00 PM

Categories: Microsoft, MSDN, SQL, Technet

Just some links to read. Carefully. There's a lot of information. These posts were made by Paul S. Randal on www.sqlskills.com. I'll do a more thorough job of weeding out information when I'm not strapped for time.

Inside the Storage Engine: Anatomy of a record
Inside the Storage Engine: Anatomy of a page
Inside the Storage Engine: Anatomy of an extent
Inside the Storage Engine: IAM pages, IAM chains, and allocation units
Inside The Storage Engine: GAM, SGAM, PFS and other allocation maps
Search Engine Q&A #20: Boot pages, and boot page corruption
Search Engine Q&A #21: File header pages, and file header corruption

This is an auto-generated list

October 15th Evening SQL Server DBA Event: Disaster Recovery - Edwin Sarmiento, MVP for SQL Server
TS: Microsoft SQL Server 2008, Implementation and Maintenance (70-432)
Protecting Data in Transit between applications and SQL Server

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Comment
Preview

Notify me when new comments are added

Steve on Security

Theoretical Headbanging at it's finest

Syndication

Recent Posts

On-Disk Data Structures in SQL Server

Related posts

Find Me

About