O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

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

The tempdb database

In some ways, the tempdb database is just like any other database, but it has some unique behaviors. Not all of them are relevant to the topic of this chapter, so some references will be made to other chapters where you can find additional information.

As mentioned previously, the biggest difference between tempdb and all the other databases in your SQL Server instance is that tempdb is re-created rather than recovered every time SQL Server is restarted. You can think of tempdb as a workspace for temporary user objects and internal objects explicitly created by SQL Server itself.

Every time tempdb is re-created, it inherits most database options from the model database. However, the recovery model isn’t copied because tempdb ...

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