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 » Performance » Data Compression   (RSS)
  • 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: 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
Privacy Statement