I'm not sure what you mean about having an identity column in a text file.

Do you mean a row number?

If so, you can add that to the query pretty easily,...

Is that column from the table you're left-joining to?

If so, it needs to go in Join On clause, not the Where clause.

Otherwise, in the outer table with no match in...

Does it get the right results?

The other thing to keep in mind is that the time results are likely from a test copy of the database. The production server is likely to have more...

Try setting the Transaction Isolation Level to Snapshot (if the database will allow that). That will help with blocking during that time.

If you have to use a cursor for this, make it STATIC instead of FAST_FORWARD. It'll probably be faster that way, and it will definitely release locks faster.

It's actually Intel's fault. Microsoft uses their terminology, because the versions actually correspond to those chip names.

There are 32-bit chips that aren't x86, and the software won't run on...

Try this, see if it does what you need. It seems to work on the sample data you gave me, but that's pretty limited.

SELECT ROW_NUMBER() OVER (ORDER BY...

If the TypeIDs in the first table were contiguous in the ID index on the second table, the scan would return just the range needed, but most likely, it's not...

sqlquest2575 (11/2/2011)

---

Thank you all for the quick response. I checked the data and i did not see any decimal value. All the data in that column is INT but just...

derek.waltho (11/2/2011)

---

Thanks for you reply I tried running this query as you have it changing the table and field names as necessary and it only ever returns the first column...

After you restart the SQL Server service (either just the service, or rebooting the server), the database engine has to recache all its execution plans, recache data, etc. Pretty...

Yes, environmental knowledge is good, but if I have time to study something job-related, I'd rather spend it on something directly within the SQL Server domain. Better ROI on...

You're welcome.

Does the data in that column store decimal values, or just integers?