SQLServerCentral Article

The Record That Never Existed (as a committed row)

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 […]

5 (1)

2021-10-01

1,833 reads

SQLServerCentral Article

A Plunge Into TOP

Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result set to a specified number of rows or percentage of rows”. The following is the […]

5 (6)

2019-06-04

4,950 reads

Blogs

Techorama 2022 Slides

By

I had a great time at Techorama. I’ll do a writeup on the event,...

Daily Coping 27 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 26 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Load balancing IPv6 UDP

By hasanobts

It seems that none of the cloud providers have internal load balancers that can...

Beginner Question about Azure SQL Database and Source Control (Azure Dev Ops)

By pakhitepo

Hi guys, I hope someone of you has the time to help me. I...

The 2022 Preview

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The 2022 Preview

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers