Technical Article

Transaction locking and row versioning guide

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.


Daily Coping 6 Oct 2022


Today’s coping tip is to remind yourself that you are enough just as you...

What you can do is based on more than your direct permissions.


What you have access to is not just what you have direct permissions to....

Registered for the Data Community Summit


I was reminded this week that I needed to get registered for the Data...

Read the latest Blogs


I must be loosing my mind. Odd data issue

By Snargables

I have a guest table on two servers. Call them prod1 and prod2. The...

How to insert data from same set of tables selecting different id from the same

By mcfarlandparkway

I am trying to insert same set of records with student id 1234 (All...

Increment max value by over a complete dataset

By GBeezy

In a weird situation where I have limited say in the ultimate solution.  Switching...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers