Re-sizing TempDB for sql server

splitTempDb.sql

/* Re-sizing TempDB to 15 GB */

USE [master]; 
GO 
alter database tempdb modify file (name='tempdev', size = 15GB);
GO



USE [master];
GO
ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev2', FILENAME = N'D:\data\tempdev2.mdf' , SIZE = 15GB , FILEGROWTH = 0);
ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev3', FILENAME = N'D:\data\tempdev3.mdf' , SIZE = 15GB , FILEGROWTH = 0);
ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev4', FILENAME = N'D:\data\tempdev4.mdf' , SIZE = 15GB , FILEGROWTH = 0);
ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev5', FILENAME = N'D:\data\tempdev5.mdf' , SIZE = 15GB , FILEGROWTH = 0);
ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev6', FILENAME = N'D:\data\tempdev6.mdf' , SIZE = 15GB , FILEGROWTH = 0);
ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev7', FILENAME = N'D:\data\tempdev7.mdf' , SIZE = 15GB , FILEGROWTH = 0);
ALTER DATABASE [tempdb] ADD FILE (NAME = N'tempdev8', FILENAME = N'D:\data\tempdev8.mdf' , SIZE = 15GB , FILEGROWTH = 0);
GO