Question : We are running the following queries using dynamic SQL, which is erroring out for few cases when we […]
Tag: nolock
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 […]
Use NOLOCK hint when calling table valued function
Question : Suppose the following function: CREATE FUNCTION [dbo].[ufnTest]() RETURNS TABLE AS RETURN SELECT 1 AS Nr My actual function […]
What are the problems with using NOLOCK given an approach to handle the short comings?
Question : I am researching the harm of using NOLOCK SQL to load data from one database that is actively […]
SQL Server data extract with limited performance impact
Question : Background: I have a SQL Server 2008 Enterprise Edition database containing three tables. The tables contain ~3 million, […]
Safe to use WITH (NOLOCK) in this case?
Question : Scenario I have a table that deals with concurrent SELECT’s and DELETE’s. I’m getting a few deadlocks on […]
How can I prove NOLOCK is the source of deadlocking problems?
Question : I’m not trying to start a windows/mac type discussion. Personally, I don’t need any convincing that NOLOCK is […]
Why is WITH NOLOCK running as Serializable
Question : I ran the following query: SELECT session_id,CASE transaction_isolation_level WHEN 0 THEN ‘Unspecified’ WHEN 1 THEN ‘ReadUncommitted’ WHEN 2 […]
Are missed rows and duplicate rows the symptoms due to allocation order scan or due to the no lock and page splits?
Question : NOLOCK results in an allocation order scan rather than an index order scan. NOLOCK doesn’t block writes because […]
How does creating an index help with NOLOCK problems?
Question : Link: https://www.brentozar.com/archive/2018/10/using-nolock-heres-how-youll-get-the-wrong-query-results/ The article mentions some problems with using NOLOCK: You can see rows twice You can skip […]
- 1
- 2