Post reply

data compression

  • May 18, 2009 at 1:33 am

    #130391

    Hi Friends,

    I have a large database and millions of records in it.

    I would like to compress the data and my data consists of both numerical and character datatypes.

    Could any one suggest me the apt way of compressing my data in 2005.

    It should also be compatiable with sql server 2008.

    Thanks.

  • May 18, 2009 at 6:49 am

    #996276

    There is no mechanism within SQL Server 2005 to compress data. You can get third party tools to compress the backups (Red Gate, Ultrabac, Quest Litespeed), but only SQL Server 2008 offers actual data compression.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 18, 2009 at 10:53 am

    #996506

    SQL Server 2008 Enterprise...

  • May 18, 2009 at 10:57 am

    #996508

    Florian Reischl (5/18/2009)

    SQL Server 2008 Enterprise...

    Yep, I stand clarified. Compression is available only on Developer & Enterprise versions.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply