TABLOCK Hint can Negatively Impact SQL Server Concurrency
In this article, we look at how using the Tablock hint in SQL Server could impact concurrency and block other sessions.
2023-11-29
Concurrency
Concurrency Challenges Around Schema Changes
A post on distributed systems and how schema changes are handled caught Steve's eye. See if you agree with how he thinks this should work.
2023-06-26
141 reads
Lock Scenarios Using sys.dm_tran_locks
Learn about the impact of locking and blocking in sessions through some demonstrations of different types of actions.
2020-06-11
8,142 reads
Concurrency Control in SQL Server
Learn a bit about concurrency problems in SQL Server, the issues they create, and the different isolation levels that help you solve them.
2020-05-12
42,497 reads
Prevent SQL Server Blocking using Lock_Timeout
In this tip we look at a way to minimize the length of blocking using SQL Server lock timeout.
2020-01-24
The Many Levels Of Concurrency
When designing for high concurrency, most people look to the hardware for answers. And while it’s true that it plays an important role, there’s a heck of a lot more to it.
2018-03-06
3,361 reads
2013-08-06
2,013 reads
Free eBook: Understanding SQL Server Concurrency
When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.
2020-11-11 (first published: 2013-07-17)
106,148 reads
Blogs
Cost Visibility: Tracking and Analysing Your Cloud Spend
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
Whiling away an afternoon, thinking
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
Black Box vs. Gray Box vs. White Box Testing
By Brian Kelley
If your organization is spending money, then meaningful results are a must. Pen testing...
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers