SQL Server Compression Ratio

  • baabhu

    SSCertifiable

    Points: 6202

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

  • M&M

    SSC-Insane

    Points: 21699

    Good question

    M&M

  • SQLRNNR

    SSC Guru

    Points: 281243

    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

  • Britt Cluff

    SSCertifiable

    Points: 5083

    Learned something new today. Thanks for submitting.

    http://brittcluff.blogspot.com/

  • Thomas Abraham

    SSChampion

    Points: 10761

    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

  • SanDroid

    SSChampion

    Points: 10068

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

  • TomThomson

    SSC Guru

    Points: 104773

    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

  • Dana Medley

    SSCertifiable

    Points: 6764

    Great question!



    Everything is awesome!

  • DBA_Dom

    SSCrazy

    Points: 2842

    Nice and simple. Thanks.

  • pjdiller

    SSC Eights!

    Points: 957

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

  • OzYbOi d(-_-)b

    Hall of Fame

    Points: 3994

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

  • EL Jerry

    SSCertifiable

    Points: 7053

    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]

  • Igor Micev

    SSC-Dedicated

    Points: 33109

    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

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Nice question, thanks.

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

  • zymos

    SSCommitted

    Points: 1960

    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 17 total)

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