Any suggestions?  I need to know.

I just ran the Estimated Execution Plan.  Actually, there's a clustered index seek that is taking 49%.  It is on the WHERE clause, it appears, on TXUYUV00.

Could specifying the UBNR...

I'm not sure what you mean by missing <table name> references.

Right now, I keep 3 days full, 2 days transaction.  A separate backup is made to burn to CD each night (I have to zip the file because it is...

I can't find anything on sp_help_revlogin.  I searched BOL and microsoft.com and can't find anything on it.

One thing about this, and to the experts it may go without saying.  Make sure you allow plenty of time for this to run, as depending on the size of...

I sent a trace to our application programmers (trace included the execution plan traces).

Does not appear to have gotten any better.  Any other ideas?

Running that right now, as no one is using this system yet.  I'll let you know what happens.

SQL Server Books online says nothing about reindexing the whole database.  Is there a command for doing that without having to pick each individual table?

I actually didn't know you could run dbreindex on the whole database.  What is this count_cows parameter?  And how do I clear the proccache?

The software is Java-based.

I updated the statistics yesterday, but have not done any kind of massive recompile on the stored procedures (some of them I created, some our vendors created).

The old box was a dual 1.3GHz Pentium IV running 2000 Advanced Server with SQL Server 2000.  Three 36GB drives in a RAID-5 array with 4GB RAM.

The OS is on C: and the RAID is D:, so it really isn't on the same RAID, I don't think (could be wrong).  The server is a member server,...