Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Yoel Martinez Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005 RE: Using CLR integration to compress BLOBs/CLOBs in SQL Server 2005
voron999
SSC Eights!
Points: 836
More actions
July 20, 2009 at 9:03 am
#1027028
OK, I found that compressing the records in a loop (I used a cursor) gets the job done with no "out of memory" issues. It is still quick enough and also restartable if needed (with little extra management coded in, that is). Worked for me.