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



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net