Tag: Locking
-
PostgreSQL vs MSSQL Locking: Architectural Differences and Practical Patterns
Mastering Database Concurrency: From MSSQL Lock Hints to PostgreSQL MVCC.
-
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…
