Introduction Whilst reading Itzik Ben Gan’s excellent book on T-SQL I came across the COMPRESS and DECOMPRESS functions. These could be quite useful for some situations that I have, so decided to have a closer look.
Compress
Or rather, on a Test or Development server instance. If you need to do this to a Live server, then you have larger issues. Most sites have servers for Developers and DBAs to work their dark magic, as well as various test servers for the next level of testing. These servers do, of course, have …
Notes on SQL 