Another question. Are you querying directly through SSMS or through an application or web service?

Connection Timeout properties can hide all sorts of places and not all of them are...

tosscrosby (5/4/2010)

---

That's why I put the caveat in there about language nuances. I knew what you meant and I'm sure Brandie did too but a newcomer might not...

He's asking if your SQL 2000 is 64 bit or 32 bit.

I don't have experience with that version of Windows, but I think I heard that running 32 bit SQL...

Sorry, guys. I'm the one who called the WhiteCoats, but I thought they were going after my local...

There's a joke here I seem to...

Roust_m (5/3/2010)

---

This is the same. If you specify "norecovery"...

Sorry, Jason. I'm referring to Gianluca Sartori's post. I should have quoted him.

You can't rely just on writes, though. Excessive reads could also be causing an issue. Especially if there's a RBAR problem in the query. Bad use of indexing could also...

I'll hold you to that. @=)

It's a neat idea, and...

Fidelity happens to be in my neck of the woods, so I found this article very interesting and very sad. It disheartens me to know that the few bad DBA...

I'd like to know the answer to Jeff's question myself. Please don't take this the wrong way, because we're just trying to help. But you seem to be making an...

Norecovery isn't going to help you. It'll leave the db in the same state as it is now. "Restoring".

CirquedeSQLeil (5/1/2010)

---

Another problem with defining the join as such is the problem of a Cartesian product. Explicitly telling the system to use an Inner join and which fields to...

And what has this...

Glad I could help. Sounds like you're on the right track for your job.