SQL Server waits for any object in transaction in the whole table before a SELECT happens. This totally threw me when I first learned about it. But the :lock option and Muz's addition in the adapter ...