Answer
TempDB stores temp tables, table variables, hash join work tables, version store, spills, and cursor data. Best practices include multiple equal-sized files and SSD storage.
Quick Answer
TempDB stores: temp tables (#temp), table variables (@table), internal work tables for sorts and hash joins, row version store for snapshot isolation, DBCC operations, and Service Broker. It's recreated fresh every SQL Server restart. All user sessions share it — heavy TempDB use is a common performance bottleneck.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ