SQL Server 2016: Introduced Data Compression Algorithm to reduce the size of Table

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

To complete this article, you must visit my yesterday’s post where I explained about the use of sp_estimate_data_compression_savings system stored procedure of SQL Server.

In this post, I continue my demonstration and am using the same example of a table from the previous post. SQL Server 2016 introduced the Data Compression algorithm for compressing or reducing the size of an object.

For more detail – visit this official LINK.

In this previous post, We can see 40% space that we can reduce of a tbl_Dumpdata table.

How?

I created a clustered index on that table, so for data compression, we have to REBUILD that index with option DATA_COMPRESSION.

Rebuild Index with DATA_COMPRESSION:

Now, check the space for PAGE option:
Check the below result, you can find the same value of column size_with_current_compression_setting and size_with_requested_compression_setting.