Page-level compression compresses data by storing repeating values and common prefixes only once and then making references to those values from other locations within the table. When page compression is applied to a table, row compression techniques are also applied.

How do you implement Page level compression in SQL Server?

1. In Object Explorer, expand the database that contains the table that you want to compress and then expand the Tables folder.
2. To compress an index, expand the table that contains the index that you want to compress and then expand the Indexes folder.

How do I compress a SQL database?

1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
2. Expand Databases, and then right-click the database that you want to shrink.
3. Point to Tasks, point to Shrink, and then select Database. Database. …
4. Select OK.