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,345 reads
There is a stored procedure that must be run by only one user at a time. In this tip, learn how to prevent multiple users from running the stored procedure at the same time.
2014-04-24
6,094 reads
Introduction into Locking, Blocking and Deadlocks in SQL Server, and why SQL Server uses these actions.
2013-11-18
10,992 reads
2013-08-02
1,951 reads
2013-06-20
2,403 reads
This article describes how the identity property was used to resolve contention in a database
2013-03-22 (first published: 2011-02-24)
18,429 reads
2010-02-18
3,597 reads
Satish More brings us a framework that you can use to execute a number of jobs in parallel and finish a task quickly.
2009-10-12
11,945 reads
2008-09-05 (first published: 2008-07-10)
2,684 reads
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Hi, we lost our sever sql2000 To restore database to a new one we...
Comments posted to this topic are about the item Do You Really Need HA?
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers