Objects in the SQL Server database are stored as a collection of 8-KB pages. This section describes the way the pages for tables and indexes are organized, stored, and accessed.
-
Table and Index Organization
-
Describes the organization of table and index pages.
-
Heap Structures
-
Explains how data rows are stored in a heap and how they are accessed and maintained
-
Clustered Index Structures
-
Explains how data rows are stored in a clustered index and how they are accessed and maintained.
-
Nonclustered Index Structures
-
Explains how index rows are stored in a nonclustered index and how they are accessed and maintained.