Temp DB Split

USE master
GO
 
-- move tempdb data
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev,
FILEGROWTH = 10% ,
MAXSIZE = UNLIMITED,
SIZE=1024MB ,
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_1.mdf')
GO
 

ALTER DATABASE tempdb ADD FILE
(NAME = tempdb_2,
FILEGROWTH = 10% ,
MAXSIZE = UNLIMITED,
SIZE=1024MB ,
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_2.mdf')
GO
 
ALTER DATABASE tempdb ADD FILE
(NAME = tempdb_3,
FILEGROWTH = 10% ,
MAXSIZE = UNLIMITED,
SIZE=1024MB ,
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_3.mdf')
GO
 
ALTER DATABASE tempdb ADD FILE
(NAME = tempdb_4,
FILEGROWTH = 10% ,
MAXSIZE = UNLIMITED,
SIZE=1024MB ,
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\tempdb_4.mdf')
GO