I have rewritten the query to perform better, but the next question I am being required to answer is why it performs OK (I wouldn't call 23 seconds ago) in...

Imagine working with T-sql that looks like this everywhere I turn.....Aaaarrrggghhh

Yes what I changed it to does work. Without playing with indexes I go from 25 minutes to seconds,...

It is just for a handful of tables; maybe 20 - 30 and there are a reasonable amount of updates with a system that already has inherent performance problems due...

The problem with out data is we update records and there is no audit trail. I really need something that writes the record somehwere before it is updated and...

Thanks so much. One thing I didn't think about was memory and it should have been my first thought. This server has rebooted on it's own with possible...

They are what HP refers to as RAID 1+0, so 3 separate arrays. None of the drives are showing up as bad.

Not on a SAN. All the drives are internal SCSI 15K. What is unusual is this pretty much happened overnight. Dedicated SQL Server so nothing else is...

We have an average of 50-100 users.

The business purpose revolves around the fact that right now the application does not perform optimally and the load of all databases on 1 server would be too much. ...