Page-Level Compression
Page-level compression is an implementation of true data compression, using both column prefix and dictionary-based compression. Data is compressed by storing repeating values or common prefixes only once and then referencing those values from other columns and rows. When you implement page compression for a table, row compression is applied as well. Page-level compression offers increased data compression over row-level compression alone but at the expense of greater CPU utilization. It works using these techniques:
First, row-level data compression is applied to fit as many rows as it can on a single page.
Next, column ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
