Move TempDB files
Quick way to change tempdb files location. This is very useful script copied from Brent Ozar. From time to time there is need to move tempdb files to new location....
Posts describing some of possible configurations related to some SQL Server settings