Tag Archives: Moving the Tempdb files

How to Optimize tempdb ?

TEMPDB, is the temporary database that is being used by SQL Server to store temporary data or temporary work. TEMPDB stores Local and global temporary tables and indexes Table variables User-defined tables and indexes Work tables for processing static or keyset cursors Work files needed for many GROUP BY, ORDER BY, UNION, SORT, and SELECT [...]