Ever seen queries freeze because a row is locked?
Use the magical, rarely-used hint:
SELECT * FROM Orders WITH (READPAST) WHERE Status = 'Pending';
This skips locked rows instead of waiting.
✔ Perfect for:
-
Queue tables
-
Background workers
-
Batch processors