Хранилища данных в SQL Server 2008

Data compression
Backup compression
Partitioned table parallelism
Star join query optimizations
Resource management
Grouping sets
Change data capture
MERGE SQL statement
Scalable Integration Services