Interview Questions
1. What is tempdb database?
The tempdb database is considered a global resource that all connections and all users can access. The tempdb database holds
user-created temporary database objects, such as temporary tables and temporary stored procedures. This database is alsoused heavily by the database engine to serialize intermediate results and to hold other temporary data and objects that are
generated during processing. Tempdb is always recreated from when the SQL Server service is first started. Because tempdb is
so heavily used by the system, many system-wide performance optimizations are necessarily focused on making tempdb as
efficient as possible.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment