September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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 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
Following the ...