Planning and Architecture (Database Engine)

Use these topics to better understand the Database Engine in Microsoft SQL Server 2008 and to plan how to implement your data storage systems. 

•  Architecture
       Pages and Extents Architecture

       Files and Filegroups Architecture

       Transaction Log Architecture

       Tables and Index Data Structures Architecture

       Query Processing Architecture

       Memory Management Architecture

       Thread and Task Architecture

•  Solution Design Considerations
       Disaster Recovery Planning

See Also

Concepts

Security and Protection (Database Engine)

Other Resources

Product Evaluation (Database Engine)

Getting Started (Database Engine)

Development (Database Engine)

Deployment (Database Engine)

Operations (Database Engine)

Troubleshooting (Database Engine)

Technical Reference (Database Engine)