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.
| Version | Enterprise | Standard | Web | Express (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 |
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
Back to all features