SQL Server 2008 Data Compression

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

Column

Dictionary

 

Create Table with Compression

 

** sp_estimate_data_compression_savings

 

Technorati Tags: SQL 2008

Comments

• Anonymous
  April 22, 2008
  PingBack from http://blog.namwarrizvi.com/?p=151