If this is a multi threaded application, use the READPAST table hint. Excerpt from BOL: Use the READPAST table hint in UPDATE and DELETE statements...
I did see the original post, I was just trying to determine if the new index did/did not change the plan. Also, try going back to the original query...
in the query plan is it doing a seek or a scan on that index ?
try changin the select to this..SELECT CONVERT(CHAR(20), [Requisition]) AS [REQUISITION], CONVERT(CHAR(30), [Part:Batch]) AS [PART:BATCH],...
Try creating an index on the OtherInfoTable on the ItemID, InfoValue fields. Hope that helps.
Run SP_CONFIGURE - make sure the affinity mask value is set to 0 for config_value and run_value. Or you can right on the server, select properties,...
Separate names with a comma.
