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:

Compression & Fragmentation:

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.

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

%d bloggers like this: