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 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.