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.
