Sample Header Ad - 728x90

GZip existing varbinary(max) column in Sql Server 2008+

5 votes
1 answer
1716 views
I have an existing legacy table that is ~180GB in size due to a client application storing PDF files as varbinary. I'd like to be able to compress that column for all rows using GZIP to help save space while I create a new solution (I was hoping there was a way to do it in SQL and not have to write client code for this). I see that the COMPRESS method is available for Sql Server 2016 but I need a solution that will work with 2008. Any ideas would be appreciated.
Asked by jewnbug97 (197 rep)
Jul 14, 2018, 07:55 PM
Last activity: Nov 14, 2019, 06:55 PM