THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s): compression
Showing page 1 of 4 (32 total posts) < 1 second(s)
  • 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
  • First Look : Red Gate SQL Storage Compress 5.0

    Recently, Red Gate Software released a new version of their product called SQL Storage Compress 5.0.  This is an alternative to using the native Data Compression and Backup Compression features introduced in SQL Server 2008.  In order to utilize Data Compression, you must be running Enterprise Edition or above (and yes, for the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 26, 2010
  • Yes, you can benefit from both data and backup compression

    Earlier today, MSSQLTips posted a backup compression tip by Thomas LaRock (blog | twitter).  In that article, Tom states: ''If you are already compressing data then you will not see much benefit from backup compression.''  I don't want to argue with a rock star, and I will concede that he may be right in some scenarios.  ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 15, 2010
  • 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
  • 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
  • SQL Server 2008 R2 : A quick experiment in Unicode Compression

    Fellow MVP Simon Sabin blogged today about one of the few engine enhancements we'll be seeing in SQL Server 2008 R2 : Unicode compression. You can read more about the topic in Books Online, but basically what is going to happen is that NCHAR / NVARCHAR (but not NVARCHAR(MAX)) columns, in objects that are row- or page-compressed, can benefit from ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 11, 2009
  • Bad habits to kick : ignoring I/O

    In my last post in this series, I talked about problems associated with creating (and using) what I call the ''uber-view.''  This time, in line with tomorrow's T-SQL Tuesday hosted by Mike Walsh, I wanted to talk about some I/O issues that tend to get ignored in a lot of environments. Introduction In my experience, today's SQL Server ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 8, 2010
  • Connect Digest : 2009-09-18

    It sounds funny, but I'm running out of things to say in this intro.  I wonder if I should introduce the list the way David Letterman is introduced differently on every episode of his late night TV show?  Anyway, one of these items was suggested to me, and one I filed myself, but the rest I just found on my own by browsing new items each ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on September 18, 2009
  • Connect digest : 2009-08-29

    I had a pretty busy week, and did not come up with much.  I know, I'm lame.  I have a series of Connect items I'd like to file regarding AutoShrink, DBCC SHRINKDATABASE, and recovery models.  And I also plan to put Unicode compression through more tests, and will file any issues I come across there.  But between upgrading my ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 29, 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
1 2 3 4 Next >
Privacy Statement