THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Compression » SQL Server 2008   (RSS)
  • Did You Know? I gave two presentations last week

    Even though I didn't make it to TechEd this year, it didn't mean I was quiet last week. On Wednesday, I was in Colorado, giving a talk for the new Colorado PASS User Group, which is a joint venture between 3 different existing groups from Colorado Springs, Denver and Boulder. On Saturday, I spoke at SQL Saturday #43, in Redmond on the Microsoft ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 14, 2010
  • Should I Compress My Indexes? New Compression Whitepaper!

    A very well written study of the compression is now available: Data Compression - Strategy, Capacity Planning and Best Practices.  This study provides guidance on best practices for designing, implementing and managing compression in your environment.  I found this whitepaper to be full of useful guidance and scripts to monitor and ...
    Posted to Lara Rubbelke (Weblog) by Lara Rubbelke on May 31, 2009
  • A Quick Look At Compression In SQL 2008

    To use compression you have to understand what your data looks like, if your data is mostly unique then compression might not really help a lot. If your data is repeated on a page then it could be beneficial. In my own test compression would improve performance with some tables and not so much with other tables. I won't explain how compression ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on April 7, 2009
  • Geek City: Two Compression Questions and Parameter Metadata

    I am teaching the SQL 2008 version of my course for the first time this week. My life is still is disarray and spare time is practically non-existent.  During the evenings after I class I am trying to get caught up on several projects that I fell way behind on over the last month when most of my time was spent in the hospital. Blogging ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 10, 2009
  • Enabling Data Compression On All Tables By Default in a SQL Server 2008 Database

    One of the great things about answering questions online is that every now and then you get one of those Aha! moments and you create a solution to a problem that once written seems really obvious and makes you wonder how that ever escaped you previously. This happened recently on the MSDN Forums, but in this case it wasn't my Aha! moment, it was ...
    Posted to The Rambling DBA: Jonathan Kehayias (Weblog) by jmkehayias on February 24, 2009
  • Backup Compression with SQL Server 2008

    SQL Server 2008 provides a feature, which, in my opinion, has been far overdue -- backup compression. For too long, if you wanted the benefit of compressed backups, you had to look at a third-party tool. Now, backup compression is built right into SQL Server 2008, and what's even better is that it's easy to use. All you have to do is append the ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 2, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement