Great trick for SQL Server
Do you know how to COMPRESS and DECOMPRESS in SQL SERVER ?
COMPRESS() - This function compresses the input expression, using the GZIP algorithm. The function returns a byte array of type varbinary(max).
DECOMPRESS() - This function will decompress an input expression value, using the GZIP algorithm. DECOMPRESS will return a byte array (VARBINARY(MAX) type).