O'Reilly logo

SQL Server 2005 Practical Troubleshooting: The Database Engine by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Tempdb Issues

By Wei Xiao

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required