Table Essentials

Tables are defined as objects in SQL Server databases. Tables consist of columns and rows of data, and each column has a native or user-defined data type. Tables have two units of data storage: data pages and extents. Data pages are the fundamental units of data storage. Extents are the basic units in which space is allocated to tables and indexes. Data within tables can be organized using partitions.

Understanding Data Pages

For all data types except large-value data types and variable-length columns when the data exceeds 8 KB, table data is stored in data pages that have a fixed size of 8 KB (8192 bytes). Each data page has a page header, data rows, and free space that can contain row offsets. The page header uses the first 96 ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.