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, ...

Get Microsoft SQL Server 2012 Internals now with O’Reilly online learning.

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