varchar(1) is definitely wrong because it adds an overhead to the table

I think the mistake author made about table variables residing in memory, not in tempdb, which was mentioned in several comments is quite serious. I think SQLServerCentral should validate the...

Andy,

Did you look at the other 3rd party tools for compressed backups, except Litespeed? What bothers me in most of them is that I do not see the results...