SQL Server Storage Structures

A DBA does 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 sees these things at a lower, physical level as

• Databases, physically stored in files

• Pages, allocated to tables and indexes

• Information, stored in slots on pages