- 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.
Thursday, October 6, 2011
Simple facts about TempDB
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment