SQL SERVER

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