pedro.ribeiro (4/1/2009)
Hi masters,I'm thinking in putting some staging tables on tempdb.
This are empty tables that receive some data from a bulk insert and then i make same validations to this data and insert it on my real tables on my user databases.
Don't. TempDB is for temp tables and other temporary objects. Either create a staging database and put your tables in there or put them in the same database as the final tables are in.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability