Export (0) Print
Expand All
9 out of 31 rated this helpful - Rate this topic

Physical Database Architecture

SQL Server 2005

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

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.