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