THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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.

Allen

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Linchi Shea said:

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

October 8, 2008 2:40 PM

Leave a Comment

(required) 
(required) 
Submit

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

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement