SQL Server Compression Ratio

  • Comments posted to this topic are about the item SQL Server Compression Ratio

  • Good question

    M&M

  • Good and straight forward.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Learned something new today. Thanks for submitting.

    http://brittcluff.blogspot.com/

  • Thanks for the question. Always good to learn a little something new, even on what is now a Monday. Keep it coming.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Great question! Staright forward and to the point. Compression is new to SQL Server backup and something we could all use more knowledge about.

  • SanDroid (4/9/2012)


    Great question! Staright forward and to the point. Compression is new to SQL Server backup and something we could all use more knowledge about.

    Nice straightforward question.

    Tom

  • Great question!



    Everything is awesome!

  • Nice and simple. Thanks.

  • SELECT 1-(compressed_backup_size/backup_size) FROM msdb..backupset

  • tks for the question - nice way to start out the week

  • Good question, nice and simple, not too complicated.

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • pjdiller (4/9/2012)


    SELECT 1-(compressed_backup_size/backup_size) FROM msdb..backupset

    To be not given 0.0000 values from your query, you first make a backup on a database with a compression option.

    The question is really good.

    Igor Micev,My blog: www.igormicev.com

  • Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Interesting question and a great selection of topic on backup compression. Always something new to add and learn.

    Thanks.

Viewing 15 posts - 1 through 15 (of 16 total)

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