Dirty reads happening in RCSI in Azure SQL Server
Although my database isolation level is set to READ_COMMITTED_SNAPSHOT, I am still getting dirty (uncommited) reads.
SELECT COUNT([random_string]) NoTx FROM [dbo].[IncTesting5];
BEGIN TRANSACTION;
INSERT INTO [IncTesting5] ([random_string]) VALUES ('UncommittedRow1'),('UncommittedRow2');
SELECT COUNT([random_string]) NoHint FROM [dbo].[IncTesting5];
SELECT COUNT([random_string]) WIthHint FROM [dbo].[IncTesting5] WITH (READUNCOMMITTED);
ROLLBACK TRANSACTION;
This query returns NoTx = 0, NoHint = 2, WIthHint =2. I would expect NoHint to equal 0.
Read more here: Source link

