Data Pages
The actual data rows in tables are stored on data pages. Figure 31.2 shows the basic structure of a data page.
FIGURE 31.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 31.4 describes the more useful fields contained in the page header.
TABLE 31.4 Information Contained in the Page Header
The Data Rows
Following ...
Get Microsoft SQL Server 2014 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.
