SoftadminUtil.Compression_Compress

 Show all Hide all
Not available in Cloud edition.

Compresses binary data.

In SQL Server 2016 and higher you can use the built-in COMPRESS and DECOMPRESS functions instead. They are not compatible with the output of this function but provide an equivalent degree of compression.

You should not make any assumptions about the algorithm used and always use SoftadminUtil.Compression_Expand to expand the compressed data.

Both the compressed and uncompressed data is held in the memory during compression so usage on large blobs should be avoided. Instead, the compression is most useful when you have a table with many rows, but each blob is no more than some dozen megabytes.

Type: Scalar function
Area of use: General use

Return value: binary

Compressed data

Parameters:

@Bytes mandatory binary
The data to be compressed.