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:
Databases, physically stored in files
Tables and indexes, placed in filegroups within databases
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 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.
