The Compression Type

Stuffing Compressed Rows

Compressing tables

Data Compression and Snapshot Isolation

Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit

Demonstrating the Effects of Using Data Compression in SQL Server

How much space would compressing a particular index will save? How will this affect query performance? Derek Colley walks you through the effects of using data compression in SQL Server.

Data compression

Storing E-mail addresses more efficiently in SQL Server - Part 2

In my last tip, I shared some ideas for determining if you should consider breaking up the e-mail addresses you're storing, even putting the domain names in a separate table. I performed storage and timing comparisons for working with 10,000 unique e-mail addresses, but I completely ignored data compression. I wanted to revisit the same test case and apply data compression to the tables and see how that impacted the outcome.

Page Compression in Heaps

Improving Data Compression Fidelity Without Sacrificing Speed

Making it easier to handle huge data sets

Scripts for Full DB Compression at partition level

Data compression is a key feature with SQL 2008. This script, can compress all DB objects (partition/non-partitioned) according to Partition Range you specifiy.