Systems Engineering and RDBMS

Data Compression in SQL Server 2008 – III

Posted by decipherinfosys on December 23, 2009

We have discussed the new data compression feature in SQL Server 2008 in the first two parts of this series – Part 1 and Part 2.  We had also covered backup compression in one of the posts – here.  We have received quite a few questions from our readers about performance impacts as well as it’s impact on fragmentation.  These topics have been addressed by MSFT on MSDN – there are two very good posts by Sunil Agarwal which address these specific points – the articles also have links to several whitepapers relevant to the compression feature:

Compression and Performance/Savings Impact: http://blogs.msdn.com/sqlserverstorageengine/archive/2009/08/16/update-on-data-compression-in-sql-server-2008-rtm.aspx

Compression & Fragmentation: http://blogs.msdn.com/sqlserverstorageengine/archive/2008/08/06/does-data-compression-lead-to-more-fragmentation.aspx

In addition, in SQL Server 2008, there was no support for compression for the Unicode data types.   That has been addressed in R2.  These are also covered in the MSDN posts here and here.

About these ads

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 77 other followers

%d bloggers like this: