Sysads Gazette

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

– Click Finish and you should have two targets – SQL1: Click on Start -> Administrative Tools -> iSCSI Initiator. – Click Yes to start the iSCSI service – Click the Configuration tab and click change – Under new intiator name, type in the name of the IQN initiator and click OK – Click on Discovery tab -> Discovery Portal…. – Enter the IP address of the Target server.