THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008... » Unicode compression   (RSS)
  • More testing of Unicode Compression in SQL Server 2008 R2

    Background Several weeks ago, I ran some tests on the new implementation of Unicode Compression in SQL Server 2008 R2 - both space-related and performance-related.  Of course it was pointed out that my performance tests were somewhat flawed, because I was using data from a very wide and atypical variety of characters sets.  I also ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 4, 2009
  • SQL Server 2008 R2 : Digging deeper into Unicode compression

    When SQL Server 2008 R2 was first released, I wrote a quick blog post discussing the additional space savings gained by Unicode compression. In one of the follow-up comments, Adam Machanic was quick to suggest that compression can bring significant CPU overhead, and can as much as double the amount of time it takes to retrieve data.  He was ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 23, 2009
  • SQL Server 2008 R2 : A quick experiment in Unicode Compression

    Fellow MVP Simon Sabin blogged today about one of the few engine enhancements we'll be seeing in SQL Server 2008 R2 : Unicode compression. You can read more about the topic in Books Online, but basically what is going to happen is that NCHAR / NVARCHAR (but not NVARCHAR(MAX)) columns, in objects that are row- or page-compressed, can benefit from ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 11, 2009
Privacy Statement