This is not a hypothetical query. Each COL represents a real column in a real table and I posted my real execution plan.

I will not divulge the column or...

My query is structured like this:

SELECT

COLMAIN_ID, COL1, COL2, COL3, COL4,

COL5, COL6, COL7, COL8, COL9,

COLText_10, COL11, COL12, COL13, COL14,

COL15, COL16, COL17_PK, COL18, COL19, COL20,...

Thanks for your reply 🙂

And, you're right, making it a full-text index is irrelevant for this query.

I can't change the data type unfortunately, other ideas are welcome!

Thanks again

Would my only option be to create a Full Text index on the table?

Disrgard - this is irrelevant to the query.

Thanks! I checked this (I have to admit I never paid much attention to that window), it was set to <default>

But, I figured out my problem.

The problem was that...

I apologize, where do I find option #2?

Other logins with their default database as master work fine but even when I drop and recreate the login in question I continue...

Steve, that is another very excellent point!

I really appreciate everyone's feedback - and you're right, it is silly, and now I feel better about making my case 😀

Its times...

That's a good point. I am not sure if it costs us in productivity or not, I will definately bring that up though!

Thanks!

That is a great question!

The data isn't static so the database is unavailable during the process which in the latest case will amount to a few hours of one business...

What section of the code are you asking about in regards to the select * from ..sysprocesses? Sorry just want to be sure I give you the right feedback 😎

Thanks!

Sandy

So glad you found it useful! Yes, sorry sometimes when you post the scripts it doesn' print out quite right. I am in a mixed environment so sometimes I get...

Thank you friends for your input, it is much appreciated and interesting to hear what others are doing in this area.

I will take your ideas along with a few of...

Perfect! Thank you for the explanation, that makes total sense and I don't know why I didnt see it, doh me!

Ok, wish me luck with the vendor..

Thanks again,

Sandy

Thanks Gail, I will email them with your suggestion.

Out of wanting to understand, how is it that this will not cause a deadlock, sorry if that's a loaded question lol

Sandy

boy that's a nasty txt file, sorry bout that 🙁

perhaps you are on to something with the serializable isolation level

I am going to talk with the developers at the vendor...