Compression in SQL Server 2008

SQL Server 2008 allows for data compression in tables, indexes, and partitions, which can save disk space and allow more data to fit into RAM, increasing query performance. Microsoft has found that in data warehousing scenarios, the new compression techniques have brought savings that have reduced the size of tables to 15 to 50 percent of their original size. Data compression in SQL Server 2008 comes in two flavors: row compression and page compression. Row Com...