Thinking that you are going through the whole table you may need to make sure that you have enough space on tempdb also!!

one more thing run UPDATE STATISTICS YourTableName WITH FULLSCAN

and Try again

if still slow can you post your execution plan ?

How much memory do you have on the server ?

Have a good weekend!!

We'll see about that!

It is going to be even more fun! to bring you out of the shell!!

Man you are fast!!

For the moment don't remove the others Just add the clustered!!

Like:

create unique clustered index IX_MY_UC on Yourtable(NumSet1,NumSet2) with fillfactor = 90

No such thing for you any more! Are you changing the IP address too ?

Besides your writting style will soon discover you

True I am doing other stuff too

ram, faster drives and faster/more cpus  all cost $$

an index is FREE

WOW!! just between a couple of back and forth I got too late

You are really fast guys huh!

Just take it one step at a time, don't be afraid, you can do it

Lets assume that you are at the last page...

I am pretty sure he is just suffering from heap fragmentation !!!

1 million rows is not supposed to bring the server down even with the subqueries we wrote !!!

My bet...

I would like you to create a clustered on (NumSet1,NumSet2) and make it unique

then try the query!

How long are you waiting?

Just create an stored procedure and pass all varibles to it.

Create all insert statements from the parameters wrapped in a transaction and check for errors after each one of them! at the...