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
  • SQL Server 2008 Data Compression: Impact of Data Distribution

    In this post, I continue to explore the implications of SQL Server 2008 data compression. It is particularly worth highlighting the fact that SQL Server 2008 data compression is performed at the page level instead of the table level. In other words, when SQL Server 2008 goes about compressing data, it does it one page at a time, and its ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on June 20, 2008
  • SQL Server 2008 Page Compression: Performance impact on table scans

    My previous post shows that data compression may not come for free, although hopefully by the RTM time the adverse performance impact on inserts will have been reduced significantly. In this post, I want to show you that data compression can enhance read performance. Intuitively, data compression may reduce the number of pages SQL Server ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on May 16, 2008
  • SQL Server 2008 Page Compression: Performance impact on inserts

    Before I begin, let me be very clear that the results I report in this post were obtained with SQL Server 2008 CTP6. Microsoft is still working on improving the performance of data compression. And in particular, the performance of inserting into a compressed table is expected to be significantly enhanced in SQL Server 2008 RTM. In my previous ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on May 12, 2008
  • SQL Server 2008 Page Compression: Compression ratios with real-world databases

    In my previous post on data compression, I looked at how rebuilding a table with page compression works with multiple processors via the MAXDOP option. In this post, I'll focus on what compression ratios I have seen in the real-world databases. Now, if you understand how SQL Server 2008 data compression works, you know that what compression ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on May 11, 2008
  • SQL Server 2008 Page Compression: Using multiple processors

    SQL Server 2008 has introduced a long sought after feature -- Data Compression. This is a great feature, and I have no doubt it'll be widely used. The key compression method is called page compression, which uses the following three techniques to reduce the space taken up by duplicates on a page: Row compression. This technique changes the ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on May 5, 2008
  • 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