Microsoft SQL SERVER
SQL Server 2008 Architecture and Configuration
SQL server editions
SQL Server Metadata
Components of the SQL Server Engine
The SQLOS
The Scheduler
Memory
SQL Server Resource Governor
SQL Server 2008 Configuration
SQL Server System Configuration
SQL Server Configuration Settings
Change Tracking, Tracing and Extended Events
The Basics: Triggers and Event Notifications
Change Tracking
Tracing and Profiling
Extended Events
Databases and Database Files
System Databases
Sample Databases
Database Files
Creating a Database
Expanding or Shrinking a Database
Using Database Filegroups
Altering a Database
Databases Under the Hood
Setting Database Options
Database Snapshots
The tempdb Database
Database Security
Moving or Copying a Database
Compatibility Levels
Logging and Recovery
Transaction Log Basics
Changes in Log Size
Backing Up and Restoring a Database
Tables
Creating Tables
User-Defined Data Types
IDENTITY Property
Internal Storage
Constraints
Altering a Table
Heap Modification Internals
Indexes: Internals and Management
Overview
Tools for Analyzing Indexes
Understanding Index Structures
Index Creation Options
Physical Index Structures
Special Index Structures
Data Modification Internals
Managing Index Structures
Special Storage
Large Object Storage
Filestream Data
Sparse Columns
Data Compression
Table and Index Partitioning
The Query Optimizer
Overview
What Is Optimization?
How the Query Optimizer Explores Query Plans
Optimizer Architecture
Statistics, Cardinality Estimation, and Costing
Index Selection
Partitioned Tables
Data Warehousing
Updates
Distributed Query
Extended Indexes
Plan Hinting
Plan Caching and Recompilation
The Plan Cache
Caching Mechanisms
Plan Cache Internals
Objects in Plan Cache: The Big Picture
Multiple Plans in Cache
When to Use Stored Procedures and Other Caching Mechanisms
Troubleshooting Plan Cache Issues
Transactions and Concurrency
Concurrency Models
Transaction Processing
Locking
Lock Compatibility
Internal Locking Architecture
Row-Level Locking vs. Page-Level Locking
Row Versioning
Controlling Locking
DBCC Internals
Getting a Consistent View of the Database
Processing the Database Effi ciently
Primitive System Catalog Consistency Checks
Allocation Consistency Checks
Per-Table Logical Consistency Checks
Cross-Table Consistency Checks
DBCC CHECKDB Output
DBCC CHECKDB Options
Database Repair
Consistency-Checking Commands Other Than
DBCC CHECKDB