SQL Server Compression Ratio

Question

Post reply

SQL Server Compression Ratio

baabhu

SSCertifiable

Points: 6205
More actions
April 7, 2012 at 4:03 pm

#254460

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

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

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

M&M SSC-Insane Points: 21700 More actions · Answer 1

M&M

SSC-Insane

Points: 21700

April 8, 2012 at 12:37 am

#1470499

Good question

M&M

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

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 More actions · Answer 3

Learned something new today. Thanks for submitting.

http://brittcluff.blogspot.com/

Thomas Abraham SSChampion Points: 10761 More actions · Answer 4

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 More actions · Answer 5

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 More actions · Answer 6

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 More actions · Answer 7

Dana Medley

SSCertifiable

Points: 6764

April 9, 2012 at 6:54 am

#1470624

Great question!

Everything is awesome!

DBA_Dom SSCrazy Points: 2902 More actions · Answer 8

DBA_Dom

SSCrazy

Points: 2902

April 9, 2012 at 7:42 am

#1470653

Nice and simple. Thanks.

pjdiller SSC Eights! Points: 977 More actions · Answer 9

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

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 10

OzYbOi d(-_-)b

SSCarpal Tunnel

Points: 4054

April 9, 2012 at 9:27 am

#1470704

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

EL Jerry SSCertifiable Points: 7063 More actions · Answer 11

Good question, nice and simple, not too complicated.

"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 More actions · Answer 12

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: 259105 More actions · Answer 13

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 More actions · Answer 14

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

Thanks.