Physical Database Architecture

The topics in this section describe how SQL Server 2005 databases and files are organized.

In This Section

Topic	Description
Pages and Extents	Describes data storage architecture.
Physical Database Files and Filegroups	Describes the set of operating-system files used to store data and log files.
Space Allocation and Reuse	Describes the space allocation algorithms and data structures. It also provides users and administrators with the knowledge they require to understand the references to the terms in the messages generated by SQL Server.
Table and Index Architecture	Describes the way the pages for tables and indexes are organized.