I was looking for a column compression functionality in SQL Server Compact and it seems that it doesn't exist (maybe I'm wrong?).
I wonder if the SQL Server Team plan to implement column compression and if yes, when can we expect it?
Thank you for your help!
Can't answer whether this is planned in the future, but can confirm that there is no compression feature in SQL CE now.
Darren
|||There is compression functionality for SQL Server 2005 (http://www.codeproject.com/cs/database/blob_compress.asp). The problem with SQL Server CE is that it does not support stored procedures and you will not be able to use this functionality. If you don't need to update the LOBs in your mobile device you can compress them in SQL Server, replicate them and decompress them at presentation time... but to answer your question we (the SQLCompress.NET people) are planning to create that functionality in SQL Server everywhere (whenever it gets released and functional)...
