So far so good!! They re-indexed and updated the stats over the weekend and things are looking better. They are going to let it ride for a day...

We think we found part of the problem. The client was not at Service Pack 2. They installed SP2 and then are going to re-index to see if...

I have been asked by pfiricano to keep an eye on this posting. We are currently waiting to hear back on the sp_helpdb results.

This is what I received back...