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.

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.

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.

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.

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.

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.

Isolation levels

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.