forum member (9/16/2009)

---

Hi,

I am still confused,whether to go ahead with lock or no lock on queries for example while one user is booking a product or editing a product...

BobMcC (9/16/2009)

---

Sorry to resurrect this old thread, but I wanted to ask a related question.

I have a user that needs access to one of my databases with a query tool....

Especially when you're talking about some huge long running query, a little bitty thing could cause contention with it, yeah. It's entirely possible that one process caused the other problems.

Ah, well, hard to know then, but I'd still be inclined to some kind of blocking. It makes the most sense based on the evidence. If it happens again, and...

Did you look at the server to see if there were other processes running, other connections with locks?

You should evaluate Wait Stats. Andrew Kelly had an excellent little article in SQL Server Magazine recently. The Instanct Doc ID was 102111.

Not being there, it's really hard to know after the fact, but on a guess... You had contention that was slowing down the rollback process. Then, when you rebooted, the...

hsac1301 (9/16/2009)

---

Hi,

I have SQL 2005 server and because of the power failure, The databse has been corrupted. I have no backup at all.

I have tried

exec sp_resetstatus 'Net'

alter database Net SET...

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...