• I think it is a wrong way to create "temp" tables in user databases, especially is the database is in the full reco mode because the transactional coherency is lost (muse perform a full backup after)

    Tempdb has been designed to store temporary table, i.e. throwable table that can be list without any risk for applications. So every temp table should be created into tempdb, and the recovery mode is simple, so no logging and strong performances, better than ddl + insert/select, in any case.