Add the following line above the...

As I already said, SQL will not automatically release memory. Don't worry about the memory. You have plenty (16GB), SQL's using 10 or so, that's quite normal and not a...

Jan Van der Eecken (5/22/2009)

---

You...

You don't need all of those. If you're looking for deadlocks, the only one that you need is 1204.

1205 adds a lot, lot more...

Why are you applying an update lock on the count? An update lock is usually used to indicate that the data selected will shortly be updated.

What are you trying to...

With that form of query, indexes are not going to help much. That particular query form performs badly, pretty much no matter what.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

As far as I know, the hidden snapshots that CheckDB uses work on every version of SQL right down to express.

Are there any errors in the error log?

If you run...

dlozi (5/22/2009)

---

In my case I'm from Africa I started using SQL server last year and i have learned a lot but,I still need the training to be come a good...

TheSQLGuru (5/21/2009)

---

I do not often waste my time coming up with such permutations as you did (or solving them) that are not relevant to the post. I...

Not using Toad. As I mentioned already in the thread, I was using the web interface that Oracle Express has.

You don't need to find and kill deadlocks. SQL has a built-in deadlock detector which will automatically find deadlocks and kill one of the processes involved.

http://sqlinthewild.co.za/index.php/2008/07/08/what-is-a-deadlock/

He is an...

Lynn Pettis (5/21/2009)

---

Paul White (5/21/2009)

---

Would be fascinating to know who 'flamed' Gail. Personally I would love to take a look at the discussion that prompted it and take the...

If you still need help (not quite sure if the problem's fixed or not), please post table definitions, sample data and expected results. See the article I referenced earlier for...

SQL will never release memory. Once it's allocated it will only release if the OS signals that the entire system is short of memory.