Row and Page Compression are features added to SQL Server 2008 and there are plenty of articles/blogs that discuss about it. I had the opportunity to play with a particular table I needed to archive and gathered some statistics while in the process. (more…)
Tags: 2008, 2008 R2, compression, include, indexes, page level compression, performance, reads, row level compression, sql server