cpu

Split SQL TempDB per number of Processor Core

Note: If you have more than 8 tempdb data files created, delete the data files after the eight (i.e. tempdev9 and above) by simply selecting each file and click remove. Split SQL TempDB Script[sourcecode language=”sql”] USE master GO CREATE TABLE #numprocs ( [Index] INT, [Name] VARCHAR(200), Internal_Value VARCHAR(50), Character_Value VARCHAR(200) ) DECLARE @BASEPATH VARCHAR(200) DECLARE @PATH VARCHAR(200) DECLARE @SQL_SCRIPT VARCHAR(500) DECLARE @CORES INT DECLARE @FILECOUNT INT DECLARE @SIZE INT