Question : Why isn’t optimistic concurrency control more commonly supported at the database layer? It is a valid alternative and […]
Tag: locking
Does ISOLATION LEVEL READ UNCOMMITTED affect Deletes?
Question : I have an exceptional circumstance that made me use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED. (I am using […]
Update Statement on one table takes locks on other tables
Question : Given the following statement on the AdventureWorks database: UPDATE Sales.SalesOrderDetail SET OrderQty = 100 WHERE ModifiedDate >= ‘2014-01-01’ […]
SQL Server – Is there a way to prevent shared range locks to ‘infinity’ when using an indexed view?
Question : I have your basic header/details table (think orders and order details). The header table has an identity column […]
SELECT … FOR UPDATE returns old value after waiting for lock
Question : It seems that if SELECT … FOR UPDATE has to wait for a lock, and meanwhile another thread […]
SELECT from table without blocking INSERTs into it?
Question : I have an application where each page load inserts information about the visit into a MariaDB table. There […]
Select query on an index column with gap locking
Question : I am trying to understand in which cases will a select query make a gap locking on an […]
avoid lock and allow two scripts to insert data in one table
Question : I have a database called db1 and I’m filling it with other two different databases, let’s call db2 […]
How do I cancel an app lock request in SQL Server?
Question : The sp_getapplock stored procedure has the following return values: 0: The lock was successfully granted synchronously. 1: The […]
Temporary database write-lock without dropping connections
Question : We have prepared a piece of software that creates a clone of our production database (SQL Server) that […]