HOLY ...! wow! That never struck me!

So you are saying that the table TABLE has duplicates on column DESC that I am now trying to create a UNIQUE NON...

P.S. to above question:

the original NC index had 2 columns - one of which was the primary key. I am re-creating the index with 1 column and dropping the primary...

Hi,

I am getting a very wierd error in the process of dropping and re-creating indexes:

Server: Msg 1505, Level 16, State 1, Line 1

CREATE UNIQUE INDEX terminated because a duplicate...

Sorry another question popped - I was just told that I need to alter the non clustered index and not drop it.

So here's what I need to do:

Table has 2 indexes...

Wonderful Thanks.

Thanks a lot for the information.

Will it have a performance impact if an ORDER BY uses the column that has the non clustered index? I will be dropping this non...