What version is COLUMNSTORE_ARCHIVE available from?

  • Hi -

    Your article mentions COLUMNSTORE_ARCHIVE, and that "This is now made possible in SQL Server 2014". However, the Microsoft documentation indicates that it's not available until version 2016.

    https://msdn.microsoft.com/en-us/library/gg492153.aspx

    DATA_COMPRESSION = COLUMNSTORE | COLUMNSTORE_ARCHIVE

    Applies to: SQL Server 2016 through SQL Server 2016.

    Specifies the data compression option for the specified table, partition number, or range of partitions. The options are as follows:

    COLUMNSTORE

    COLUMNSTORE is the default and specifies to compress with the most performant columnstore compression. This is the typical choice.

    COLUMNSTORE_ARCHIVE

    COLUMNSTORE_ARCHIVE will further compress the table or partition to a smaller size. Use this option for situations such as archival that require a smaller storage size and can afford more time for storage and retrieval.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply