RBarryYoung (6/23/2009)

---

They wouldn't let me use that one I wanted too, though. I have attached it here...

Training trends... Not sure. I'd be interested to see what others say about this. As to where to get training, I can make a couple of very good suggestions. In...

Thoses correlated sub-queries inside the case statements are probably leading to Loop Join operations across the three million rows worth of data. Generally, but not always, you're better off dealing...

Requests & Transactions are different.

A request has a SessionId. This can be used to get to the sys.dm_tran_session_transactions dmv. This then links to sys.dm_tran_active_transactions through the transactionid.

So, yeah, a request...

Hey, Buck Woody just posted a "Help Me, Help You" post that some of our more infamous posters, and quite a few others, could use. Thought you all might be...

Oh, lordy. That's too much like work. After about the third SELECT DISTINCT, I lost interest. Sorry.

There are always exceptions, but in general, you're better off using the LEFT JOIN. When in doubt, write the query both ways and look at the execution plans.

You can. I don't have a link for you. It's just:

EXEC @param1=42

I just want to echo what everyone else has said. Without at least an execution plan, it's just not possible to say what's going on.

I can suggest that you try...

I was really nervous opening this up, expecting to get 34,000 lines. There are only 14. Had me going for a minute there.

Anyway, 34,000 is more than a little extreme....

suhas.wadadekar (6/19/2009)

---

Thanks. I'll try it out.

Dropping a database and creating a new one is an option. But, I was trying to avoid dropping the procedures and functions written for the...

dan (6/19/2009)

---

Right,

Sorry for my previous brief posts with bad spelling and grammer. Here is what I have found:

The optimiser deals better with a sub query look up rather than a...

Except for third party databases, all our databases are built from source, so we can drop the database and recreate it pretty much by pushing a button.

However, you could look...

Once you've established blocking, you need to understand why there is blocking. It could be poor performance requiring index or query tuning or it might be transaction management or contention...

An index that has all three columns, which makes it covering. It can also be covering if one or more (or all three) of the indexes is in the clustered...