Data Compression

Pros

Less disk space
Faster writing and reading
Faster file transfer
Variable dynamic range
Byte order independent

Cons

Added complication
Effect of errors in transmission
Slower for sophisticated methods
Unknown byte / pixel relationship
Need to decompress all previous data

also look at this link for example: https://www.experts-exchange.com/articles/10159/SQL-Server-Compression-Pros-and-Cons.html

Manish Kumar9y ago

Thanks Manas Sir.

Just to confirm can we do compression on billions of records. I have already gone through those links (Mostly describes concepts not real time pros and cons). But implementing those things on production server, expecting some answers who has already implemented this concepts or can share their experience

Manas Mohapatra9y ago

Follow below article that may help you:

https://technet.microsoft.com/en-us/library/dd894051(v=sql.100).aspx

http://blog.sqlauthority.com/2010/03/01/sql-server-data-and-page-compressions-data-storage-and-io-improvement/

https://www.mssqltips.com/sqlservertip/1582/implementing-data-compression-in-sql-server-2008/