Viewing 4 posts - 1 through 4 (of 4 total)
Quest Discovery Wizard for SQL Server
January 3, 2014 at 12:04 pm
#1677405
Which is more efficient, individual indexes on Proj_Start and Proj_End or a composite index on Proj_Start and Proj_End?
November 2, 2010 at 7:54 am
#1245371
1. The @Iteration set statement needs 'AND C.index_id = I.index_id' added to 'JOIN SYS.INDEX_COLUMNS C'
SET @Iteration = (SELECT MAX(C.KEY_ORDINAL)
FROM SYS.INDEXES I
JOIN SYS.OBJECTS S -- Joining on...
March 12, 2010 at 4:11 pm
#1133058
From the perfmon counters, it looks like you are doing 1 insert per transaction.
Transactions / Sec : 1921 ( For SQL Database)
Would it be possible for you to batch several...
February 26, 2010 at 11:18 am
#1125739