Delete files over 30 days old

You can delete files older than a specific age using the forfiles command. This command first became available with Windows Server 2003 and Windows Vista. If you are on Windows XP, you can copy the forfiles.exe command from a 2003 server and run it since they share...

Add multiple tempdb files

Microsoft recommends servers with many CPUs and cores start out with 8 tempdb files to prevent contention. From there you can monitor and adjust the number of files. There is a bug that will prevent the use of multiple tempdb files if they are not all the same size....