Post reply

compressed data in database

  • January 30, 2009 at 6:11 am

    #935458

    You could upgrade to 2008 which has compression built in.

    The other option that comes to mind is to compress them using, something, pkzip?, and then store them as a binary. That would work, but it will certainly slow down the storage & retrieval of the data.

    "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

  • January 30, 2009 at 10:12 am

    #935694

    Ok

    It seems that this is the only solution...

    I need to use it in 2005...so I will try your way

    Thanks

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

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