pedro.ribeiro (4/1/2009)
1) TempDB is all reconstructed every time the server (SQL Server) Starts, correct?
Correct
2) If the answer to the first question, is yes, this means that the stating tables that i have created the last time on tempdb , now (that the server restarted) are lost and i have to create them again. Correct?
Correct
Do you know if you lose perfomance when inserting (from a bulk_insert) data to a staging table on a tempdb Vs on a staging table in a user db?
Humm.. I am not so sure but may be it depends on your disk configuration? not sure though