transaction isolation

SQLServerCentral Article

The Record That Never Existed (as a committed row)

  • Article

Introduction According to the official documentation, the READ COMMITTED isolation level “specifies that statements cannot read data that has been modified but not committed by other transactions”. So, one could think that a record returned under this isolation level existed in the committed state at the time of reading. In this article, I am going […]

(1)

You rated this post out of 5. Change rating

2021-10-01

2,160 reads

Blogs

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Monday Monitor Tips: SQL Auditing Preview

By

One of the features we advocates have been advocating for is a better way...

Read the latest Blogs

Forums

Creating JSON I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON I

Expensive CPUs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Expensive CPUs

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers