Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there any specific enhancements in SQL Server 2012 for Data Compression Feature?

Last time I checked SQL Server 2008 R2 introduced support for Unicode characters so columns with NCHAR data types (excepts CLOBS and BLOBS) can now take advantage of compression technology in SQL Server.

share|improve this question
    
"SQL 2008 R2 introduced support for Unicode characters" -- what? –  Jon Seigel Jan 2 at 19:27
2  
@JonSeigel Not sure if you were just pointing out that it is clumsily phrased but clearly talking about technet.microsoft.com/en-us/library/ee240835.aspx –  Martin Smith Jan 2 at 19:41
    
@Martin: I thought the statement meant that n[var]char columns could not be compressed in 2008, which didn't make sense. So 2008 R2 added additional compression on these column types, correct? I was unaware of that. –  Jon Seigel Jan 2 at 19:50
    
@JonSeigel Yes. Also normal row compression doesn't do anything to nvarchar/varchar but the unicode compression will apply there. –  Martin Smith Jan 2 at 20:48
    
@Martin: I see. Got it. Thanks. –  Jon Seigel Jan 2 at 23:33
show 1 more comment

1 Answer

up vote 3 down vote accepted

There were under-the-covers performance enhancements (nothing concrete, see for example this book excerpt. Otherwise, no, 2008 R2 compression and 2012 compression are functionally equivalent.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.