Skip to content

Instantly share code, notes, and snippets.

@hasokeric

hasokeric/sql.sql

Created August 31, 2016 15:34
Show Gist options
  • Save hasokeric/d7296a4efde546e2c81cc64cdde791d0 to your computer and use it in GitHub Desktop.
Save hasokeric/d7296a4efde546e2c81cc64cdde791d0 to your computer and use it in GitHub Desktop.
Download ZIP
E10 wants you to have 1 TempDB File Per Each CPU on SQL
Raw
sql.sql
ALTER DATABASE tempdb
ADD FILE (NAME = tempdev2, FILENAME = 'W:\tempdb2.mdf', SIZE = 256);
ALTER DATABASE tempdb
ADD FILE (NAME = tempdev3, FILENAME = 'X:\tempdb3.mdf', SIZE = 256);
ALTER DATABASE tempdb
ADD FILE (NAME = tempdev4, FILENAME = 'Y:\tempdb4.mdf', SIZE = 256);
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment