August 2009 - Posts

• A Unicode Compression example

  Now that we have Unicode compression available in SQL Server 2008R2 as described in, let me take a simple example using AdventureWorksDW database to show you the additional compression that can be achieved on tables with one or more columns of type NCHAR Read More... Posted Monday, August 17, 2009 4:37 AM by Sunil Agarwal | 0 Comments Filed under: Data Compression

• Unicode Compression in SQL Server 2008R2

  In my previous blog , I had mentioned that unicode compression will be available as part of next SQL Server release named SQL 2008R2. You can down load the CTP2 version http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx to play with it. This is a new Read More... Posted Monday, August 17, 2009 2:00 AM by Sunil Agarwal | 0 Comments Filed under: Data Compression

• Customer feedback on Data Compression

  As I described in my previous blog , the data compression feature has been very successful. We do appreciate all the feedback that we have received as this provides us a way to know how customers have been using the feature and the challenges they are Read More... Posted Monday, August 17, 2009 1:44 AM by Sunil Agarwal | 0 Comments Filed under: Data Compression

• Update on data compression performance/space-savings and links to published white papers

  It has been a while since I blogged about data compression so I thought it will be good to provide an update on data compression usage within SQL Server community. I am happy to say that the Data compression feature has been a tremendous success in SQL Read More... Posted Sunday, August 16, 2009 9:11 PM by Sunil Agarwal | 0 Comments Filed under: Data Compression