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 » data compression   (RSS)
  • Playing with page compression - for real

    During maintenance windows and against test databases, I have been applying page compression to some largish tables (~200+ million rows, ~50GB).  These tables are heavy write and medium read, but all writes are inserts (no updates).  Clustered indexes are on a DATETIME column, and then on INT columns.  Since there will be very ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 28, 2009
  • Connect Digest : 2009-12-12

    Sorry I have been quiet recently; been working very hard for the past two weeks on a migration of an old, tried SQL Server 2005 database to a brand new 2008 cluster with faster SAN undercarriage, double the memory and twice as many CPUs.  I'll blog more about that later, because other than a few user errors, the whole process was actually ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on December 12, 2009
  • 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
  • Performance / Storage Comparisons : MONEY vs. DECIMAL

    As you may already know, I am not a big fan of the MONEY data type, because of its inflexibility, accuracy problems, and the expectations the name of the type evokes in new users.  If I had my way, MONEY would become a synonym for DECIMAL in SQL Server 2008 (allowing for specific precision and scale), and be removed in the following ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 27, 2008
Privacy Statement