Data Pages
The actual data rows in tables are stored on data pages. Figure 34.2 shows the basic structure of a data page.
Figure 34.2 The structure of a SQL Server data page.
The following sections discuss and examine the contents of the data page.
The Page Header
The page header contains control information for the page. Some fields assist when SQL Server checks for consistency among its storage structures, and some fields are used when navigating among the pages that constitute a table. Table 34.4 describes the more useful fields contained in the page header.
Table 34.4 Information Contained in the Page Header
The Data Rows
Following the ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
