I don't believe it does but I'll test and profile just in case. Thanks.

Thanks for the reply, Brian. The paths used are purely as an example and not used in production.

Yes, folder permissions are possibly an option, but I wanted to try and...

Yes, I...

Lamprey13 (4/1/2010)

---

Since you have a compound index, you *might* see a gain by changing the where clause by pulling out the common term. For example:SELECT Document, rc

FROM ...

Duplicate and missing records on queries without NO LOCK hints too?! Thats a very simple but clear explanation and seems it could be common occurence than with the NO LOCK...

Thanks Lamprey. Missing and duplicating records on commited data becuase of NO LOCK hints is news to me. Hopefully this will be something we encouter few and far between. Something...

Thanks for the detailed analysis Paul, I understand why the query is slow from your explanation.

Moving the data to a SQL2008 server stops the speed issue. The updated optimizer must...

Ok, there wasn't as many as I thought.

The primary key is PREFIX, DOCUMENT, SEQNO in that order, all ascending.

CREATE INDEX [Corder] ON [dbo].[ILines]([COrder]) WITH FILLFACTOR = 90...

Comments removed as no longer valid.

Thanks for the...

Thanks for the reply.

No, this test was on a SQL2000 server (using 2008 Managemeent studio). I'll move the data to a 2008 SQL sever to see if the results are...

As Chris has already advised, you are trying to insert the same data into the table which is already there.

Your primary key on this table is the columns OrganizationNumber &...

Also, if the SEQNO is the same value on the 2 clauses, it returns the results instantly too. If they are different, the delay is there. < This is really...