I am worling on sql server 2000.
I have 2 ques
1. I want to delete the duplicate rows from my table
key is suppid and empid means want to delete duplicate records of same suppid and empid.
2.I have one table with 10 fields.I dont have any primary key in this table.when i perform the delete operation (just delete from table no more where conditions) its taking long time to delete.
is there any way to speed up it can i create index on this table if can to which field i have to create because i dont have any where condition in my sql query.
Pl help me thanks