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

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features