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,323 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
7,406 reads
2013-08-02
1,797 reads
2013-06-20
2,315 reads
This article describes how the identity property was used to resolve contention in a database
2013-03-22 (first published: 2011-02-24)
17,817 reads
2010-02-18
3,588 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
9,925 reads
2008-09-02 (first published: 2008-07-10)
2,658 reads
By HamishWatson
This blog post is how to get git going after upgrading to Catalina (10.15)....
By HamishWatson
This blog post is about the situation where after upgrading to the latest macOS...
By John
If you are at involved with the #sqlfamily, you are bound to hear about...
Comments posted to this topic are about the item STRING_SPLIT with Index as Table-Valued...
Comments posted to this topic are about the item Protecting Data from the Inside
I have a field called 'jsonpayload' in a table called 'auditlog' that is populated...
Ask SSC