Understanding Data Structures

SQL Server DBAs and users do not see data and storage the same way SQL Server does. A DBA or end user sees a database more logically as the following:

Image Databases, physically stored in files

Image Tables and indexes, placed in filegroups within databases

Image Rows, stored in tables

SQL Server internally sees these storage structures at a lower, physical level as

Databases, physically stored in data and log files

Pages within ...

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

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