How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option

COLUMNSTORE_ARCHIVE option was introduced with SQL Server 2014. If we want to archive ColumnStore Tables or Indexes, we can compress our columnstore tables or indexes with this option.

For example, you partitioned a columnstore table by a date column. And you want to save space by compressing old partitions. In this case, you can compress old partitions with COLUMNSTORE_ARCHIVE option. So you can save up to 15 times.

Compress a ColumnStore Table

Decompress a ColumnStore Table

Compress a ColumnStore Index

Decompress a ColumnStore Index

Comress Only Some Partitions on a ColumnStore Table