Sorry for the delay in replying...

According to the developer I just asked, it's ix.

Well, we resolved the issue.

Two of the columns were nvarchar(max) due to SQL DBA's extreme laziness (that's me). Once I throttled that down to a 'mere' 500 each, it...

I totally agree with you. And this isn't really a low use environment. In fact one of the two dbs is a blobs db (images).

But it IS government,...

PS to answer the questions posed:

2 processors, 2 Gb RAM and a SAN drive.

Thank you both for taking the time to respond to my request. I apologize for not getting back to you sooner.

We have resolved this issue. Before addressing the...