Gail,

Thank you for your suggestions. Your suggestion about sargable predicates has helped me to find an alternate way to invoke the query to get SQL Server to use the...

Brian and J,

Sorry about that. My eye stopped on the wrong line.

And, please don't confuse "Grasshopper" with inexperienced. Just because I'm new to SQL Server Central doesn't mean...

Ten,

If someone wants to look at table and index structures that tells me that they don't have a general idea of what they're looking for or where they expect to...

Sean,

You can ask me specific questions about the tables and indexes that relate to this problem, but I will not publish my table and index structures on this forum for...

Sean,

Yes, I have tried removing the NoLock hint. It makes no difference.

Roy,

RDP'ing and opening SQL Server directly on the box works fine. No slowness or unresponsiveness.

Since my last post I have also discovered that at least one other person in...

Roy,

I have no problems at all RDP'ing to the server. It's only the SQL Server connection that is slow and unresponsive.

Also, I have no problems connecting to any other...

Thanks, Lowell. I'll check it out.

Thank you!

That's exactly what I was looking for!

Much Grass!

:w00t: