P0004 – Data Compression

[Peter Jones]

Here are some useful links on Data Compression for SQL Server.

https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/row-compression-implementation?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/page-compression-implementation?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-estimate-data-compression-savings-transact-sql?view=sql-server-ver15

A typical compression command that would compress all data in a table and it’s indexes would be as follows:

 alter table dbo.stg_address REBUILD PARTITION = ALL   with (data_compression = Page) ;

Best Regards
Peter Jones

[Author]

Posts