Row Versioning

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

The Importance of Patch Management to Avoid Downtime

By

A recent Microsoft outage caused by a bad patch pushed out to Windows instances...

Friday Flyway Tips–Comparison Defaults

By

One of the little details that I find matter more and more in enterprises...

A New Word: Solysium

By

solysium – n. the unhinged delirium of being alone for an extended period of...

Read the latest Blogs

Forums

AG-Group primary during reboot

By mlorek

New to ag groups.  I have a 2 node aggroup.  We are doing maintenance...

Synapse Analytics History I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Synapse Analytics History I

A Programmer's Attitude

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Programmer's Attitude

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers