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

You should be able to attach them. SQL should be able to recreate the log files. Do you not have any db backps?

I hope this is not a production...

DBCC commands are T-SQL statements. Run them in your query tool of choice (management studio, query analyzer, sqlcmd, etc)

You can see the thread you're responding to. Scroll down below the reply box. The box is collapsed by default, but once you expand it (icon in top right of...

I can't seem to see the list of latest posts I've made. Maybe I'm missing it. I use that frequently when away from my work machine to follow up on...