Database Pages
All information in SQL Server is stored at the page level. The page is the smallest level of I/O in SQL Server and is the fundamental storage unit. Pages contain the data itself or information about the physical layout of the data. The page size is the same for all page types: 8KB or 8192 bytes (before version 7.0, the page size was 2KB). The pages are arranged in two basic types of storage structures: linked data pages and index trees.
Page Types
There are eight page types in SQL Server, as listed in Table 33.4.
Page Type | Stores |
---|---|
Data | The actual rows, found in the tables |
Index | Index entries and pointers |
Text and Image | Textual and image data |
Global Allocation Map | Information about allocated (used) extents ... |
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.