However, one customer, ServiceU, estimated it would save between $25-$50K in its first year using SQL Server 2008 Data Compression. Now, that news will even make Ebeneezer Scrooge happy.

I tested Advanced Compression in two ways, against two separate databases. In the first case, the database I used for testing was generated from the TPC-C order entry benchmark, which simulates a ...

Data Compression is one of my favorite features in SQL Server 2008 because, surprisingly, there does not appear to be a downside. Flick a switch to save storage and improve performance.