Have you looked at the wait statistics to understand what the server is experiencing waits on? Further, capture the waits at the start of one of the slow processes and...

Stone...

GilaMonster (6/27/2014)

---

How? Top without an order by I can see, MIN (the minimum value)...

Yes

Chord77 (6/27/2014)

---

Spoke to my manager this morning.

He wants my primary role to be process improvement and creation. I've done it (successfully) in the past, but that wasn't the...

Almost impossible to give you substantial suggestions without at least seeing the execution plan, but a couple of points. Do you really need the DISTINCT clause. That's going to cause...

Anyone think they can help this person? I think they really need it, and what's more, deserve it. 6.5? Please, no.

Wow! Well done.

I'm mainly working 2008 & up, so I'll be happy to help with that stuff.

Good luck on the DTS issue.

Since your question is 2000 specific, you might get better responses posting it in a 2000 forum. I haven't touched a 2000 server for several years now, let alone messed...

That's an indication the optimizer thought that operator would be executed 200 times. It may or may not be depending on the accuracy of your statistics. You can run the...

Without the plan itself, not just a picture, it's really hard to say. Can you post the execution plan? An actual plan would be preferable to an estimated one.

You might also want to look up sp_whoisactive by Adam Machanic.

Assuming you're talking about two different server instances and two different sets of file locations so that each server is pointing to a different file, the names don't need to...

And chances are really good if you don't have a DBA around that there are statistics inside the databases that need to be updated, there may be query tuning opportunities,...

There are two kinds of execution plans, estimated and actual. To get an estimated plan inside SQL Server Management Studio, you simply type:

EXEC myNewProc 'myparameter';

Highlight that command and within Management...