TheSQLGuru (5/20/2014)

---

1) Did the test finish more quickly with CPUs pegged? That could be an indication that things are running 6X faster. Not likely, but not unheard of...

Ouch! This doesn't take into account the sort order of the keys! It will identify these two indexes as duplicate:

CREATE NONCLUSTERED INDEX [idx01] ON [dbo].

(

[d5comp] ASC,

[d5jbns] ASC

)

CREATE NONCLUSTERED...