O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required