TEMPDB - as it sounds it is a temporary database in SQL Server, that has undergone number of changes from 2005 version onwards. As you may be aware that tempdb is used for various purpsoes such as storing intermediate results, sorting and keepng row versions...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Tue, Feb 15 2011
Filed under: Filed under: sql server, best practices, storage, system, tempdb, tsql, extent, benchmarking, performance monitoring, contention, dmvs