SQL Server 2008 Compression
Jonathan Allen and Chad Boyd have interest blog posts on the new SQL Server 2008 compression features. Row level compression drastically reduces the meta-data needed for variable length columns. Instead of storing the length of each field in 2 bytes, it now takes a mere 3 bits. Fields themselves are also smaller. Storing a 1 … Continue reading SQL Server 2008 Compression