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