SQL 2008 Compression

Question

I am an intern and was asked to do some research on SQL 2008 data compression. We want to store several parts of outlook emails in a table. The problem is that we want to store the entire email body in a field, but then want to compress it. Using Char() will not store the whole body, but will allow compression... using varchar() will store the entire body but not allow compression. Any ideas on how to store the whole body AND compress it?

Thank You for your replies!

Answer 1

Types of data compression in SQL Server 2008

Creating Compressed Tables and Indexes

Whitepaper: Data Compression: Strategy, Capacity Planning and Best Practices