Post reply

Compression

  • August 29, 2005 at 1:09 pm

    #363559

    Does SQL Server 2000 provide any options for compressing stored data?

  • August 29, 2005 at 2:04 pm

    #585974

    SQL server and using compressed data is not a good idea.  Granted you can use Windows compression to manage your disk space HOWEVER, everytime the system needs to access the system it will uncompress, change data, recompress.....  Lots of overhead...



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • August 30, 2005 at 11:31 am

    #586230

    You might want to try SQLLiteSpeed which stores backups compressed.

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

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