As a DBA, you constantly seek ways to optimize SQL Server database performance. One option is TempDB, a widely misunderstood system database that has a critical impact on how your SQL Server performs. Learn in this video what TempDB is for, how SQL Server uses it, how best to set it up, and how to tell if it’s a performance problem.
[youtube yNR_fLutIPE]
Video producer: http://www.brentozar.com/