Yes - same chassis, but with redundant power supply and a back-up generator power to the server room.

I did update stats on all objects with fullscan.

The subquery in the criteria statement was the culprit. I removed it Friday evening b/c not only is that really inefficient but,...

What was the fix in your case?

Service packs up to date, nothing in the log that looks abnormal.

I did discover some a useless bit of sql: a nested query in a Where clause that was responsible...

Thanks for your help, I tried to update all stats a few times now, also rebuilt indexes - I hoped that would be all it was. To clarify what I...