NOLOCK double counting is how three people in a lunch line turn into four lunches. Nothing was inserted. One row moved ahead of the scan and got read twice. I tested it on SQL Server 2025 and share a query that catches it on your own table.
NOLOCK Can Miss Rows: The Order That Was Never Missing
Yes, NOLOCK can miss rows. A row can vanish from your report while it sits safely in the table. Nobody deleted it. The read simply walked past it.
UPDATE Without WHERE Clause: The Day Everyone Got a Raise
An UPDATE without WHERE clause changed 8,432 salaries. When ROLLBACK can help, and how to check the affected row count before COMMIT.
SQL SERVER – Setting Deadlock Priority to Control the Transaction that is Rolled Back
In this article, we will explore Setting Deadlock Priority to Control the Rolled Back Transaction. Let us explore more in this blog post.
Before You KILL a Session: Estimating the Rollback Cost
Before you KILL a session, inspect its transaction age, log bytes, current command, and likely rollback work, then monitor the undo safely.
Transactions and Variables – SQL in Sixty Seconds #150
Transactions and Variables both are not related at all. There is no impact of a transaction on a variable. Let us learn about it today.
SQL SERVER – CREATE Statement in TRANSACTION
Recently my client of Comprehensive Database Performance Health Check asked me if we can use the CREATE statement in the TRANSACTION or not.