Data Warehousing and Data Science

11 March 2010

SQL 2008 Data Warehousing Features

Filed under: Data Warehousing,SQL Server — Vincent Rainardi @ 12:06 am
Tags: ,
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 Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

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

Twitter picture

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

Facebook photo

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

Connecting to %s

Blog at

%d bloggers like this: