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

Tables and Index Data Structures Architecture

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.