Compressing Tables, Indexes, and Partitions

SQL Server 2008 Enterprise Edition supports on-disk storage compression for tables stored as heaps, tables stored as clustered indexes, nonclustered indexes, and indexed views. Because you can configure compression of partitioned tables and indexes independently for each partition, different partitions of the same object can use different compression settings.

Using Row and Page Compression

The storage engine handles all aspects of compression. SQL Server 2008 supports two types of compression:

  • Row compression

  • Page compression

Row compression affects the physical storage of data within rows. Most data types are affected in some unique way, but no application changes are required because of these changes. ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.