2 out of 2 rated this helpful - Rate this topic

Tables and Index Data Structures Architecture

SQL Server 2008

SQL Server 2008 R2
SQL Server 2005

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.

In This Section

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD