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 content of the articles. In case if erroneous information was published, it should be removed from the site.

Currently, when all our comments are hidden in the discussion, the reader may be seriously mislead.

Please fix it!