Tag Archives : data compression


A little more about compression

Happy Monday folks!  Ready to talk some more about compression? Unicode Compression Another type of compression new in SQL Server 2008 is Unicode compression.  This is basically row compression for nchar and nvarchar datatypes.  Per BOL, SQL Server uses the Standard Compression Scheme for Unicode (SCSU) algorithm to achieve up to 50% space savings on […]


Page compression (!)

Ok kids, last time I introduced row compression, today I want to take the next step and talk about page compression.  Now, whereas row compression removed NULL and 0 values from each individual record, page compression removes redundant values from a table.  Redundant data is stored on the page only once, and subsequent occurrences will […]

dictionary compression