Post reply

Data compression

  • October 22, 2012 at 8:47 am

    #393436

    Hi,

    Can anyone tell me if SQL 2005 supports, like 2008 and 2012, data compression?

    Data compression can have the downsize of CPU having to decompress data but the IO when reading is faster since it reads less pages, so it's a trade-off... i think..

    Thanks,

    Pedro

    PS: I'm asking this since I only have 2008 and 2012 installed...


    If you need to work better, try working less...

  • October 22, 2012 at 9:31 am

    #1551455

    Data compression was added in SQL Server 2008 and therefore is not applicable to SQL Server 2005. If you review the following MSDN link on SQL Server data compression, you will find that SQL Server 2005 is not available in the other versions drop down list.

    http://msdn.microsoft.com/en-us/library/cc280449.aspx

  • October 22, 2012 at 9:35 am

    #1551460

    Thanks


    If you need to work better, try working less...

  • October 22, 2012 at 11:05 am

    #1551540

    But, you can get it if you need it from 3rd party products such as Red Gate SQL Storage Compress[/url].

    "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

  • October 22, 2012 at 2:01 pm

    #1551627

    Grant Fritchey (10/22/2012)

    But, you can get it if you need it from 3rd party products such as Red Gate SQL Storage Compress[/url].

    Thanks Grant... Still reading your book on query tuning... 🙂

    Is the statement I wrote true, supposing the CPU is fast but the IO is not very good?

    Data compression can have the downsize of CPU having to decompress data but the IO when reading is faster since it reads less pages, so it's a trade-off... i think..

    Pedro


    If you need to work better, try working less...

  • October 22, 2012 at 7:08 pm

    #1551700

    PiMané (10/22/2012)

    Grant Fritchey (10/22/2012)

    But, you can get it if you need it from 3rd party products such as Red Gate SQL Storage Compress[/url].

    Thanks Grant... Still reading your book on query tuning... 🙂

    Is the statement I wrote true, supposing the CPU is fast but the IO is not very good?

    Data compression can have the downsize of CPU having to decompress data but the IO when reading is faster since it reads less pages, so it's a trade-off... i think..

    Pedro

    Yeah, in general, compression acts to make I/O faster, in most cases. There are exceptions.

    "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 6 posts - 1 through 5 (of 5 total)

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