Kalen Delaney

SQL Server Concurrency: Locking, Blocking and Row Versioning

Your application can have impeachable indexes and queries, but they won’t help you if you can’t get to your data because another application has it locked. That’s why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney’s book is your guide.

5 (2)

Kalen Delaney

2013-08-26

3,232 reads

SQL Server Concurrency eBook Download

SQL Server Concurrency: Locking, Blocking and Row Versioning

Your application can have impeachable indexes and queries, but they won’t help you if you can’t get to your data because another application has it locked. That’s why every DBA and developer must understand SQL Server concurrency and how to troubleshoot excessive blocking or deadlocking. Kalen Delaney’s book is your guide.

Kalen Delaney

2012-10-02

3,202 reads

Blogs

Drop Database Objects Practically Risk-Free!

By administrator

FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...

Lengthen a Primary Key–#SQLNewBlogger

By Steve Jones

Another post for me that is simple and hopefully serves as an example for...

Setup SQL Server Alert to get automatically notified of database blockings

By SQLPals

Suppose you want to or need to know anytime your SQL Server is experiencing...

Read the latest Blogs

Forums

Protecting Data Between Services

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Protecting Data Between Services

SQL browser and port number

By John Deupree

We have several new servers running SQL 2014.  Some servers are single instance servers...

ssms crashes when editing .sql script

By Samwell

I’ve recently been having an issue with ssms freezing and crashing while editing a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers