Ninja's_RGR'us (8/8/2011)
Not to be too anal here, but you can't really add NC indexes, you can only add NC constraints.
And a unique constraint is enforced by a unique index, by default a nonclustered one. Other than splitting hairs was there a point?
If the column that you want to have the index on is not unique, well, I had that in the example above...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability