Hey Guys,

Thanks again for your suggestions.

@Grant, you are right, the query you pointed out is sub-optimal, it didnt matter to much though as that table is small and

the query...

Hey guys.

Thanks for all your replies.

Ok, I restructered the index again and created a clustered primary key on both bigints (combined, ascening) , the temporary

as well the large target table....

Grant, I have been there before.

I used the 2 bigints as a combined, primary clusered index with no performance improvements, rather the opposite, it was even slower on

inserts. :S

Hey Guys,

Thank you for replying.

I shall try to get all information together you asked for.

Target (large table) definition: 10 columns, int, int, datetime, datetime, varchar(1024), varchar(512), bigint, bigint, bigint, bigint

unique...