THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

SQL 2008 Data Compression - Linchi Shea

Last night at the NYC SQL Server Users Group meeting Linchi Shea presented a session on Data Compression (not Backup Compression) in SQL Server 2008.

By understanding how the compression algorithm works, and tuning your clustered indexes based on that understanding, you can achieve some pretty incredible space savings on disk, and performance benefits due to the increased amount of data loaded into cache. His analysis is available from his blog post SQL Server 2008 Data Compression: Impact of Data Distribution.

His explanation was clear and I learned a lot from his session. (I am in New York to do some performance testing at the Microsoft Technical Center, where the meetings are held every Fourth Thursday of the month.)

If you happen to be in New York and can spare the time, I highly recommend this group. It was well worth my time.


Published Friday, September 26, 2008 11:07 AM by AllenMWhite



Linchi Shea said:

Thanks for the feedback and plug for our users group! Appreciated it.

October 8, 2008 2:40 PM
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement