Chapter 9. Tempdb Issues
In This Chapter
The basic concept of tempdb is simple: It is a system database. This means it is always present as long as SQL Server is working. It stores temporary data. This means if SQL Server is restarted, you lose all data stored in tempdb.
What kind of data can you store in tempdb? Just about anything. To the user, it is just like a regular database. You can use transactions and all the other SQL Server features, so long as you do not care about saving the data after stopping the SQL Server service.
If you store a small amount of data in tempdb, the data might not actually need to be written ...