InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 20:56:44 GMT20http://www.sqlservercentral.com/Forums/Topic515568-149-1.aspxYou would need to do the compress / decompress in a CLR stored procedure or in a CLR function. CLR would need to be used because you would be accessing an external DLL to do the compress/decompress. If you take this route you will need extensive testing, especially to look for memory leaks in the external DLL. If memory does leak, then eventually you will have to restart SQL to reclaim the memory.It would probably be safer to get the application to do the compress/decompress, as this will keep any memory leaks outside of SQL Server and safeguard your SQL Server SLA.Fri, 27 Jun 2008 02:25:12 GMTEdVassiehttp://www.sqlservercentral.com/Forums/Topic515568-149-1.aspxsearch for the xpFileUtils.dll :this provides a set of extended stored procedures which will help to decompress/compress data using LZ/L7 algorithm.Thu, 26 Jun 2008 19:00:54 GMTkoustav_1982http://www.sqlservercentral.com/Forums/Topic515568-149-1.aspxdo you know any specific user defined function for zip/unzip?Fri, 13 Jun 2008 17:54:28 GMTjagadish_sdshttp://www.sqlservercentral.com/Forums/Topic515568-149-1.aspxFor example I get credit report as xml file and its around 6MB size. I can store it in database. Event I can zip (compress) and store it in Database the size of the credit report is very less.The zip/unzip I want to do it in database while inserting/updating/selecting the credit report, not in application.Fri, 13 Jun 2008 17:52:58 GMTjagadish_sdshttp://www.sqlservercentral.com/Forums/Topic515568-149-1.aspx[quote][b]jagadish_sds (6/11/2008)[/b][hr]I want to compress the values and insert/update to table and when selecting the values I want to decompress it and select.Is there any functions/methods available in sql server 2005?. I can do it in Application side and send compressed values to database, but I want to do it in database itself.[/quote]you could create user defined functions for such things but client-side seems more appropriate for these things.Fri, 13 Jun 2008 09:07:37 GMTnoeldhttp://www.sqlservercentral.com/Forums/Topic515568-149-1.aspxYour description is pretty vague. Can you describe what you mean by compress/decompress. How about giving us some examples using SQL statements and sample data? It would help us help you quite a bit more.Wed, 11 Jun 2008 16:33:19 GMTJohn Rowanhttp://www.sqlservercentral.com/Forums/Topic515568-149-1.aspxI want to compress the values and insert/update to table and when selecting the values I want to decompress it and select.Is there any functions/methods available in sql server 2005?. I can do it in Application side and send compressed values to database, but I want to do it in database itself.Wed, 11 Jun 2008 16:14:21 GMTjagadish_sds