SQL 2008 Data Warehousing Features

11 March 2010

Filed under: Data Warehousing,SQL Server — Vincent Rainardi @ 12:06 am
Tags: Data Warehousing, SQL Server

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

No comments yet.

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s