Row and Page Compression in SQL Server 2008

Row compression is used to minimize storage at the row level by compressing fixed-length data types.


Page compression is used to minimize storage for redundant data stored in pages.