'. . . My guess is that SQL Server is using Page Locks for the INSERTS instaed of Row Locks even though I specify WITH (ROWLOCK) table hint.'

'. . ....

This is kind of by design. Without a literal value, the optimizer cannot use your CHECK constraint to locate the member, because it ignores the the content of the variable....

Yes, do it right, then tune. In fact you can summarize with indexed views and still keep your table 'correct', but watch out for blocking in the indexed view when...

Forgot!

Another side effect of long cluster keys is that the risc that one of the columns in the index will be updated is higher.

And anytime you update a cluster...

"first one having Clustered index(Also PKey on 5 cols )and 2 other indexes on imp columns(i suppose)second table also Clustered index(PKey 6 cols) and 2 non-clustered indexes."

I think you should...

quote:

--------------------------------------------------------------------------------

"it is worth noticing that an UPDLOCK rather

than a HOLDLOCK may save the show. An UPDLOCK is a shared lock, so it

does not block readers. However, only one process...

"if you ever need the new value do:

update dbo.zMaster

set @RegNumber = RegistrationKey = RegistrationKey + 1

It works great, I couldn't make it fail, but it scares me. Is this double...

jpipes request for seeing some errorhandling code is actually a very good tip, because the errorhandling code is essential for your problem, as your script will generate a conversion deadlock...

I have a complex sp that is responsible for selecting, locking and returning the next call in a call centre. It is tricky because I have to ensure that...

quote:

---

I have a complex sp that is responsible for selecting, locking and returning the next call in a call centre. It...