SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Daily SQL Server 2008 New Feature – Day 5

  Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

 Wednesday 12th May 2010

Data Compression

Enable data to be stored more effectively, and reduce the storage requirements for your data. Data compression also provides significant performance improvements for large I/O bound workloads, like data warehousing.

Any pain points from anyone that has adopted this new functionality ?


Posted by Steve Jones on 13 May 2010

It takes more CPU to do this, but it's usually outweighed by less IO taking place. However if you are CPU bound instead of IO bound, this could be an issue.

Leave a Comment

Please register or log in to leave a comment.