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
Last activity: Nov 14, 2019, 06:55 PM