• Check this great article by Wayne Sheffield:

    http://www.sqlservercentral.com/articles/Temporary+Tables/66720/

    -- Gianluca Sartori