Compression Functions

Jovan Popovic shows us the COMPRESS and DECOMPRESS functions in SQL Server 2016:

These functions use standard GZip algorithm so you can compress data in application layer/client side and send compressed data to SQL Server, or you can compress data in SELECT query and DECOMPRESS it in client side.

This seems potentially useful if you’re going to store blobs of data you don’t need to parse.

Related Posts

Backup Compression And Encryption

Arun Sirpal shows the combined effects of backup encryption and backup compression in SQL Server 2017: Do not forget about the certificate! Warning: The certificate used for encrypting the database encryption key has not been backed up. Imagine if you need to recover the backup and you can’t?  You will get the dreaded thumbprint error. […]

Read More

Finding Compressable Indexes

Tracy Boggiano has a script to help you figure out which indexes make sense to compress: We can write procedure check periodically rather a table will benefit from compression or not.  There are a few tricks though: If you have sparse columns you cannot compress the table, we check for that in lines 70-74. Next […]

Read More

Categories

December 2015
MTWTFSS
« Nov Jan »
 123456
78910111213
14151617181920
21222324252627
28293031