Sugesh,

Thanks for a timely reply. What I wanted to accomplish was taking advantage of using the backup to tape devices as a Plan-B. Plan-A is  using filesystem backups for full, diff...

Peter,

That RAISERROR might do the trick. Excellent suggestion...DUH , I should have thought of that!

--Frank

Colin,

You kind of answered my question, but it just seems a bit funky that no conclusions can be drawn...for example. If you had two identical servers - one with 1...

It seems you already have you answer, but FWIW...

I had a similar problem, but I handled it differently due to my application/environment. See my post http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=329377#bm330390

One thing you should...

Colin,

Thanks for the book recommendation....less that $20 for a like-new harcover copy from a used book vendor on amazon.

--Frank

FWIW...

Here is an article on the Microsoft site called SQL Server 2005 Waits and Queues http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc

I will read it and see if it can help me on my SQL2k...

Thanks for the replies. I created a thread a month or so ago on a mass delete I was undertaking. I am still working on it as my maintence windows...

All FK have indexes.

--Frank

Thanks for all of your helpful hints. Thay have pointed me in the right direction and kep me from wasting time where it's not needed.  That has made my job more bearable. Now...

Ninja's_RGR'us,

We do have a new server that we will migrate to. There is a planned migration, but the clients are PC's (about...

GilaMonster,

Thanks for posts.  I know I have a lot of quesions. I just wrote a response and the system did what I thought was a POST, and then it did...