Understanding Locking in SQL Server - SQL Server Tutorial

In this video you will understand what is locking in SQL Server? video gives brief overview Following:
What is Resource types in locking of SQL Server?
What is Lock Modes in SQL Server?
It gives live view of looking at different type of lock modes as well as the resources types where the locks are placed. It describes in greater detail about RID, Key, Page, Extent, Table and DB Resource types in SQL Server Locking concept. It also explains Shared Locks, Update Lock, Exclusive Locks, Intent Lock, Schema Lock and Bulk Update locks in SQL Server.

Blog post link for the video with script

Complete Step by Step List for DBA Tutorial Videos:

[sharma.shubham]

Too much knowledge to gain in 25 minutes. Great video 😊

[TheEyepox]

at 10min when you were talking about the Update LCK type, it is not a deadlock, you are confusing it with a regular lock, a deadlock is when you have Two Transactions as in your case but let's assume that Tran01 wants to Update Tab1 and then Update Tab2 and Tran02 wants to Update Tab2 and then Update Tab1, you run both procedures or queries alongside and that is when you get a deadlock, at which point SQL Server kills one of those depending on a few criteria, your example when both Transactions are fighting solely on one resource (table in this example) is a regular lock which will just make the last transaction to ask for Update Lock to wait until the first finishes.

[rajdeeprana]

Very useful to understand locking in SQL Server.. Thanks Tech Brothers..

[eespiedrop]

That's a really useful explanation. Thanks for taking the time to put it together.

[krismaly]

Awesome video with good explanation on SQL Server Locks
All Developers should know this much information and good refresh for DBAs.

Narrator see to be very good at topic.
I enjoyed watching this video and recommend others to watch.

Thanks for educating the community and appreciate your efforts in publishing this video.

Please keep publishing some more videos.

Thanks a bunch

[reachmaximum]

Simply Awesome, Words are not enough to congratulate you.Thanks a lot.Gaining More and more knowledge from your videos.Look forward for more which can be useful to DBA's.

[ottmiller]

You explained very well and simply. Thank you.

[MegaRsha]

Amazing video. That was really helpful

[vjeparis]

your all videos are osm and really helping me in my training period!!

[technovice]

Another very informative video. Thank you so much.

[ymadhurireddy]

THis made me clear. THank you very much

[anandbalu]

That was really helpful. Thank you for sharing

[karnikjoshi]

Can you please explain basic difference between tablock and bulklock practically? I am bit confused in this so..

[DobbyGloving]

So is it safe to say that shared locks don't actually lock anything? They just let the DB that we are retrieving data from that resource?

[sql_training]

It's not exactly the right model to explain a deadlock. :)

[robertwest]

Yeah, your description at 10min is totally wrong. This is not a Deadlock....this is a Blocking situation where 1 transaction will get the X lock, transaction 2 will wait (Blocked) until Transaction 1 is finished. Deadlocking is where Trans1 has a lock on Resource A and wants a lock on Resource B, and at the same time Trans 2 has a lock on Resource B and wants a lock on Resource A. One Trans will be killed in that situation. The situation you have drawn will not cause this situation. You should fix this video as Deadlocking and Blocking are 2 entirely different things.

[gunjanyadav]

Sir you are too fast. You should speak slowly while teaching a particular topic