SQL2008 R2 - Whats New - Unicode Compression

Digging into SQL Server 2008 R2 there is very little in the engine that has changed.

One great feature is unicode compression. So if you use nvarchar(n) and nchar(n) you can save lots of space.

From books online, most european langauges you will save 50% space.

From books online

"Unicode compression in SQL Server 2008 R2 uses an implementation of the Standard Compression Scheme for Unicode (SCSU) algorithm to compress Unicode values that are stored in row or page compressed objects. For these compressed objects, Unicode compression is automatic for nchar(n) and nvarchar(n) columns. The SQL Server Database Engine stores Unicode data as 2 bytes, regardless of locale. This is known as UCS-2 encoding. For some locales, the implementation of SCSU compression in SQL Server 2008 R2 can save up to 50 percent in storage space"

Locale

Compression percent

English

50%

German

50%

Hindi

50%

Turkish

48%

Vietnamese

39%

Japanese

15%


-
Published Tuesday, August 11, 2009 1:06 AM by simonsabin

Comments

Tuesday, August 11, 2009 7:35 PM by Aaron Bertrand

# SQL Server 2008 R2 : A quick experiment in Unicode Compression

Fellow MVP Simon Sabin blogged today about one of the few storage engine enhancements we'll be seeing

# Something for the Weekend: SQL Server Links this week 14/08/09 | John Sansom - SQL Server DBA in the UK

Pingback from  Something for the Weekend: SQL Server Links this week 14/08/09 | John Sansom - SQL Server DBA in the UK

Tuesday, August 18, 2009 7:20 AM by Beyond Relational

# SQL Server 2008 R2 August CTP – What is new in Database Engine Features?

SQL Server 2008 R2 is a minor release and the number of features and enhancements added to the database