Baratella Marco (9/16/2009)

---

Thanks for your answer.

I have read something about parameter sniffing but I think my problem is a bit different.

I execute twice the same query with the same parameters:...

There's no way to know for sure which it will do, but I'm fairly certain that the likely path is for it to simply use the compound index and then...

Can you post an actual execution plan? And if you really want help rewriting the query, then sample structure and sample data should be supplied as well. Read the link...

What you're describing sure sounds like a classic case of parameter sniffing. Do a search for that term and you'll find a lot of options for fixing it. Sometimes, the...

There are two ways it can do this, index intersection and index joins. It's not common for the optimizer to make these choices though. If you've got two indexes on...

If you have a problem that you can document that you're seeing with memory, it'll be possible to help. Otherwise, there's very little you need to do with memory on...

Huge topic and you're going to get disagreement from almost everyone one counter or another. Best approach is to start with simple, basic counters and expand from there. I'd focus...

You can set the database to single user mode or, what I usually do, restricted user mode and use WITH ROLLBACK IMMEDIATE. That will remove all the connections and leave...

You can get an idea of which queries use those indexes by using the execution plans available in the plan cache, yes. You should be able to run an XPath...

Inexpensive, Red Gate's SQL Compare. Fantastic tool.

GSquared (9/15/2009)

---

I worked out the ROI and cost-of-implementation for buying monitoring software vs building it ourselves. Buying would, long-term, cost less, and short-term, be in place immediately, while building...

If you want short articles, I'd suggest doing a search in the Search box near the top of the screen here. There are a ton of articles on how to...

I'd go a bit farther and suggest if you're even thinking about putting locking hints into your query, then you need to reassess your system, it's design, the queries you're...

This is an estimated execution plan, not the actual execution plan, so there may be other issues that I can't see with this. The thing that jumps out at me...

Solid Quality instructors travel. A lot. You can also pay a little extra and bring them to your location directly. My...