Tag: Performance
-
When and How to Use Locking Hints in SQL Server?
In a perfect world, the SQL Server Query Optimizer works perfectly. It automatically decides when to use Shared (S) locks for reading and Exclusive (X) locks for writing, while following the rules of your transaction isolation level (usually…
