On Twitter recently, I asked:
Does anyone I know use the
DECOMPRESSfeatures in T-SQL?
To those who replied in the affirmative, I asked:
What made you decide on this as opposed to
Read on to learn the responses. In my case, I’ve seen
DECOMPRESS used in two places. First, compressing large product descriptions (large enough to go to LOB). Second, I use it to compress binary models created via SQL Server Machine Learning Services. Some of those models compress quite nicely.