Thursday, October 6, 2011

Simple facts about TempDB

  • When you create a temp table using # prefix that table will be created in TempDB.
  • TempDB is newly created when ever SQL Server is restarted.
  • Certain oprations cannot be performed on TempDB such as backup and restore, changing collation, changing schama name, drop the database etc.

No comments:

Post a Comment