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