Search code examples
sqlsql-server-2008compressioncharvarchar

SQL 2008 Compression

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!

Solution

  • Types of data compression in SQL Server 2008

    Creating Compressed Tables and Indexes

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