Impact of page compression on data warehouse loads

As a data warehouse professional you are faced with some trade-offs. One of them is speed versus space. The article below shares some interesting facts about applying compression to tables. It indicates the affect page compression has on bulk load times vs table size.

What is required is to balance load times (speed) vs disk storage (space).

Page compression consistently returns the fastest query response times.

My DWH suggestion: load into heap and add clustered index with page compression afterwards.

What’s your thoughts?

Page compression with bulk loading


*Image provided is from Microsoft.

This entry was posted in SQL Server 2014 and tagged , . Bookmark the permalink.

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 )

Google+ photo

You are commenting using your Google+ 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