SQL Server 2008 Data Compression

  • Article

Key changes in SQL Server 2008 Data Compression

Data compression enables you to store your data more effectively and reduce the storage requirements for your data. SQL Server 2008 provides significant performance improvements for large I/O bound workloads such as data warehousing. SQL Server 2008 also provides native support out-of-the box for backup compression.

 

Row format

image

Column

image

Dictionary

image

 

Create Table with Compression

image

 

** sp_estimate_data_compression_savings

 

Technorati Tags: SQL 2008