A very well written study of the compression is now available: Data Compression - Strategy, Capacity Planning and Best Practices. This study provides guidance on best practices for designing, implementing and managing compression in your environment. I found this whitepaper to be full of useful guidance and scripts to monitor and manage compressed tables.
The paper starts with tips and tools to help decide what to compress. It then guides the reader through considerations for implementing compression and estimating necessary resources to complete compression. The final sections of the paper provide guidance and evidence on management topics – space management, performance management, partition management.
I am certain that those who are considering compression will find these concepts, scripts and tools to support the full lifecycle of compression. I know that I will keep this on my short list of favorite whitepapers!