Microsoft SQL Server 2012 Internals

Chapter 6. Table storage

Kalen Delaney

This chapter starts with a basic introduction to tables and then continues into some very detailed examinations of their internal structures. Simply put, a table is a collection of data about a specific entity (a person, place, or thing) with a discrete number of named attributes (for example, quantity or type). Tables are at the heart of Microsoft SQL Server and the relational model in general. In SQL Server, a table is often referred to as a base table to emphasize where data is stored. Calling it a base table also distinguishes it from a view, a virtual table that’s an internal query referencing one or more base tables or other views.

Attributes of a table’s data (such as color, size, quantity, order date, ...