Understanding Locking, Data Modification and Committing Data in SQL Server
Learn about how SQL Server uses locks when modifying data and how data is committed to a database after data changes.
2023-10-23
Learn about how SQL Server uses locks when modifying data and how data is committed to a database after data changes.
2023-10-23
2023-10-09
420 reads
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.
2022-10-05
This article isn’t about the act of lock escalation itself, which is already well documented and generally well understood. Some myths (like row locks escalating to page locks) persist, but challenging those yet again probably wouldn’t change much.
2022-09-19
2021-01-04
632 reads
2020-11-02
504 reads
Learn about the impact of locking and blocking in sessions through some demonstrations of different types of actions.
2020-06-11
6,115 reads
2020-02-20
648 reads
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.
2018-05-18
5,850 reads
2016-01-19
1,340 reads
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...
USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...
Comments posted to this topic are about the item Backing Up Master