Understanding Locking in SQL Server - SQL Server Tutorial

[@sharma.shubham429]

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.

[@marvinalone]

yes, you are right coz sql server introduced U lock, but the authoer was also right as he was explaining the scenario and assumed if there were no U lock in sql server, or why sql server introduced U lock

[@krismaly6300]

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

[@TechandArt]

Hey u can join this one alao

[@eespiedrop2]

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

[@rajdeeprana0720]

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

[@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.

[@TechBrothersIT]

+Avinash Alladi Thanks very much for kind words dear!

[@ramakrk2009]

amazing. No one can beat you sir

[@TechBrothersIT]

+Rama Kambhampati :) Thank you so very much for kind words! I am very happy to know that you liked the tutorial.

[@vjeparis]

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

[@TechBrothersIT]

Glad to hear that our effort is helpful. Good luck!

[@MegaRsha]

Amazing video. That was really helpful

[@ottmiller4028]

You explained very well and simply. Thank you.

[@TechBrothersIT]

Hi, thanks for watching the video, please join www.techbrothersforum.com to ask any question that you may have. Tech Brothers and other professionals are online at the forum to help you out quickly. Thanks

[@Sql_100]

You did great thank you for sharing

[@technovice2024]

Another very informative video. Thank you so much.

[@ymadhurireddy]

THis made me clear. THank you very much

[@anandbalu100]

That was really helpful. Thank you for sharing

[@TechBrothersIT]

You are most welcome. Thanks you watching.

[@VijayPatel-rt2yt]

Thank you for sharing your knowledge!

[@TechBrothersIT]

Ram Patel You are welcome Ram.

[@JamesR2187]

Excellent!! very helpful.

[@TechBrothersIT]

+James joy Thanks for watching!

[@karnikjoshi2325]

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

[@yaddu8]

good explanation...Thank you

[@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?

[@aflibnush]

James Dobson I guess

[@naomimwakanyamale2695]

you are the best

[@MdAshiquzzaman]

It's a really useful .

[@sqltechzpestechz7053]

U r awesome

[@parixitsinhchauhan5171]

nice video.. very informative

[@SUDHAKARANDE]

nice video. thank you so much

[@moncysamu]

Dead lock explanation is wrong

[@salehheba]

very helpful ,thank you

[@TechBrothersIT]

+H Saleh You are welcome and thanks for watching.

[@samiliqali4025]

thank you

[@kbipan]

well explained :)

[@catsarereallycool]

Excellent!

[@theperfecttime5508]

Thank you!

[@robertwest4596]

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.

[@naveedshah15]

big thanks

[@YouTickTech]

Good one

[@ajiteshmalhotra]

Really you confused me now.

[@danezubro]

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

[@gunjanyadav8848]

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

[@spirridd]

Useless and harmful material