Features

Data compression in SQL Server

SQL Server, Azure SQL Database, and Azure SQL Managed Instance support row and page compression for rowstore tables and indexes, and support columnstore and columnstore archival compression for columnstore tables and indexes.. GeoPITS brings you the comprehensive details of Data compression's support in different versions & editions of SQL Server.

Explore Data compression In Different SQL server Versions & Editions

VersionEnterpriseStandardWebExpress (Adv.)Express
Version v2019 Yes Yes Yes Yes Yes
Version v2017 Yes Yes Yes Yes Yes
Version v2016 Yes Yes Yes Yes Yes
Version v2014 Yes
Version v2012

Frequently Asked Questions

SQL Server, Azure SQL Database, and Azure SQL Managed Instance support row and page compression for rowstore tables and indexes, and support columnstore and columnstore archival compression for columnstore tables and indexes.

You can find more details about this version here

We run all kinds of Database services that vow your success