Search This Blog

SQL Server 2008 Top New Features :Data Compression

Data compression reduces the amount of storage space needed to store tables and indexes, which enables more efficient storage of data. Data Compression does not require changes be made to applications in order to be enabled.

  • Save disk storage

  • Enable compression option for individual tables or indexes

  • Configuration is easy using the Data Compression wizard

  • Applications do not need to be reconfigured as SQL Server handles compression and decompression of data

  • Compression can improve disk I/O and memory utilization