Data Compression

Question

What is data compression. Can we compression on crores of data on production server with out any down time.

Daniel Jones · Answer

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 Kumar · Answer

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 Mohapatra · Answer

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/