It is interesting to see how a blog evolves with the time and user interacts with each blog post. Earlier I wrote two of the blog posts on NOWAIT and SET LOCK_TIMEOUT. I have received very good response on this subject. Please read following two blog posts before continuing this blog post.
SQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query
In earlier blog post SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query, we learned how we can use NOWAIT query hint to not wait on any locked query and return error. The Query Hint works on query and table level. There is…
Read MoreSQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query
Everybody knows about NOLOCK but not everyone knows about NOWAIT. They are different and they have an entire different purpose. In this blog post we will not talk about NOLOCK but we will see how NOWAIT will work. The idea of writing about blog post is based on the question…
Read MoreSQL SERVER – Difference Between Update Lock and Exclusive Lock
I have often got this question on this blog as well in different SQL Training. What is the difference between Update Lock and Exclusive Lock? When Exclusive Lock is on any processes no other lock can be placed on that row or table. Every other process have to wait till…
Read MoreSQL SERVER – 2005 – Mechanisms to Ensure Integrity and Consistency of Databases – Locking and Row Versioning
Today I was going through Book On Line while researching something, I come across one interesting small article about two mechanisms to ensure integrity and consistency of databases – 1) Locking 2) Row Versioning Let us see their definition from Book Online Itself. Locking Each transaction requests locks of different…
Read MoreSQL SERVER – Introduction to Live Lock – What is Live Lock?
Some questions are very interesting to answer. I just received following question in Email. What is Live Lock? A Live lock is one, where a request for exclusive lock is denied continuously because a series of overlapping shared locks keeps on interfering each other and to adapt from each other…
Read MoreSQL SERVER – Locking Hints and Examples
Locking Hints and Examples are as follows. The usage of them is the same but the effect is different. Let us learn it today together.