Subscribe to this blog
Briefcase
Print
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.