New data warehousing features introduced in SQL Server 2008:
- Merge: faster loading
- Changed data capture: enables us to drip changes from DW to DMs, or from ODS/OS to DW
- Resource governor: query is given higher priority over loading/processing
- Minimally logged insert: faster loading
- Star join query/bitmap filter: faster reports
- Backup compression: small loading batch window
- Data compression: less disk space, value of investment
- Parallel query on partition tables: faster query on snapshot fact tables
- Partitioned aligned indexed views: faster query on fact tables
- Grouping sets: faster query from reports
- Change tracking: real time, lightweight propagation of data changes into DW
Leave a Reply