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,155 reads

Blogs

The PASS Data Community Summit 2025 Recap

By

It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...

Microsoft Post-Quantum Crypto APIs Are Now Generally Available

By

I mentioned this in my talk on Quantum Computing at the PASS Data Community...

SQL Server 2025 Generally Available

By

This was announced last week at Microsoft Ignite and it's been covered by others...

Read the latest Blogs

Forums

The Ending Substring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Ending Substring

Done is Better than Good

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Done is Better than Good,...

Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...

Visit the forum

Question of the Day

The Ending Substring

In Azure SQL Database and SQL Server 2025, if I run this, what is returned?

SELECT '[' + SUBSTRING('Steve Jones', 7) + ']'

See possible answers