The data compression feature in SQL Server 2008 helps compress the data and help reduce the size of the database. As well, because compressed data is stored in fewer pages, you get improved I/O performance for intensive workloads. However, it all comes at a cost, extra CPU resources are required on the server to compress and decompress the data. Therefore, it is important to understand the workload characteristics when deciding how to best implement compression.