Locking

Technical Article

Transaction locking and row versioning guide

  • Article

In any database, mismanagement of transactions often leads to contention and performance problems in systems that have many users. As the number of users that access the data increases, it becomes important to have applications that use transactions efficiently. This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.

You rated this post out of 5. Change rating

2022-10-05

Blogs

Join me at the Microsoft Fabric Community Conference with a discount code

By

I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...

Is Your Business Truly Ready for AI?

By

The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...

Data Governance: The Invisible AI Accelerator

By

Introduction Do you remember the effort of tidying up your BI and reporting systems,...

Read the latest Blogs

Forums

Time Outs Here

By Ahr Aitch

Several times in the last couple of days I've had submissions time out with...

Data Diagrams: Data Types with Column Names

By Ahr Aitch

In the ss below I highlighted several rows in each block showing tables in...

Data Diagrams: Data Types with Column Names

By Ahr Aitch

In the ss below I highlighted several rows in each block showing tables in...

Visit the forum

Question of the Day

Counting Bits III

What is the output of this code in SQL Server 2022?

select bit_count(0xEF)

See possible answers