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....
TempDB configuration check
TempDB is heavily used database in every instance, time to check it. As every DBA know TempDB database is shared for all sessions within DB engine. This makes its performance...
Size summary
Returns summary of all data within SQL Server instance grouped by type. Tempdb database size excluded. Script can be handy during analyze of instance, disk drives sizing, memory sizing etc....