• The NTFS file system comparison is great!

    Sometimes you compress by using file/folder attributes because you get seamless access to the file, it's convenient and you get some compression benefits for some acceptable overhead.

    Likewise, sometimes explicit compression is better - you offload the compression overhead to another one-off task, but you lose the ease of access.

    As always, it really depends.   I do agree with others though; it was a great article from the point of view of seeing just what sort of things you can do in the DB engine with the new CLR integration - good or bad - and is a welcome distraction from some of the more mundane DBA task articles