SQL SERVER – Locking, Blocking and Deadlock – Quiz – Puzzle – 9 of 31

Click here to get free chapters (PDF) in the mailbox

Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

SQL SERVER - Locking, Blocking and Deadlock - Quiz - Puzzle - 9 of 31 9 A query always ran in split second, but suddenly it started to timeout. A quick look at the error log shows that the cause was deadlock. What is a Deadlock and how can we identify and resolve a Deadlock inside SQL Server 2008 R2

Link to participate in SQL Quiz

Notes of Vinod Kumar

The concepts of locking and blocking have been a mystery for many people. But becoming a deadlock victim is even stranger than it can get. Even today lots of product companies that come to performance tuning at peak loads get this. It boils down to coding practices. Here’s a Hint for you.

Notes of Pinal Dave

The frequently asked question by many novice DBAs is: “what can I do to reduce deadlocks?” Deadlocks often occur due to inappropriate access to the objects by T-SQL code. There is a big difference between time out and deadlock. The real answer will include a suggestion to resolve both of them efficiently.

Additional Notes

SQL Server Interview Questions and Answers ISBN: 1466405643 Page#56-57
Simple Example of Snapshot Isolation – Reduce the Blocking Transactions
TRANSACTION, DML and Schema Locks
Introduction to Live Lock – What is Live Lock?
Applying NOLOCK Hint at Query Level – NOLOCK for whole Transaction


There are exciting prizes awaiting the winners. Click here for Prizes and Frequently Asked Questions.

Link to participate in SQL Quiz

Note: The SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Using RANKING Functions Instead of SQL Looping Logic of Cursor – Quiz – Puzzle – 8 of 31
Next Post
SQL SERVER – Reasons for Using Output Clause – Quiz – Puzzle – 10 of 31

Related Posts

No results found.

Leave a Reply