Hi Greg,
The index added covers the fields in the locking strategy.
*CREATE NONCLUSTERED INDEX [IX_Shipping_StatusID_IsLocked_LockedBy]*
*ON [dbo].[Shipping] ([StatusID],[IsLocked],[LockedBy])*
*INCLUDE ([OrderID])*
Yes, locking strategies like this aren't always the best strategies,
Hi Tony,
That summary will be pretty close to the mark.
What’s the index that was added though?
Adding an index can lead to deadlocks, as it’s another object that needs to be
updated when the data is updated.
Few questions though:
* What’s the index that was added look like?
* Have