The major groups are fine. The forums within them seem to be changing order every time I visit.

In the forums, posts only. Generally, but not always, high post count shows someone who spends time answering questions, hence contributing to the site.

It's not difficult to get the QotD...

Questions are still multiple choice, but they're based off a business case given, usually a couple pages worth. As a very rough, very simplified example. (the question may not have...

What do you want the result to look like?

Rather than use nolock, move any select statements that you can out of the transaction completely. This will shorten the duration of the transaction, as well as reducing locking.

Thanks. None of them are serious, though the doubling lines has the possibility of getting very amusing very quickly. :hehe:

Try also leaving the parameters and marking the proc for recompile every time it runs. (CREATE PROCEDURE ... WITH RECOMPILE)

Using variables, the optimiser can not make any conclusions about the...

There are 1000 milliseconds in a second, but even with that, it looks odd. How many CPUs do you have?

Are these lock waits? What's the full object and counter...

Mal Content (9/26/2007)

That's odd. Everything I have read says it's better not to have compound indexes because the optimizer can deal with separate indexes more efficiently. Do you have...

Thought so. I have a similar issue that appears from time to time.

What happens is that the stats for a date-time column get out of date and the optimiser...

You could try breaking the proc up into smaller procs. Check when transactions start and end and reduce them to the smallest necessary size.

Run profiler with the deadlock chain event...

Personally, I don't have a problem with some developers having very limited access to the production dbs. Key phrase...

Look in books online for sp_attach_single_file_db. That should do the trick.

If you're using windows authentication, then have the domain admins create a windows group for the developers and grant that access to SQL.

If you're using sql authentication, you'll have...

Did you remove builtin admins as well? If not, windows authentication will get you in. I presume you don't know the sa password.

I've never tested this, but from what I've...