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
http://sqlage.blogspot.com/2015/04/un...
Complete Step by Step List for DBA Tutorial Videos:
http://sqlage.blogspot.com/search/lab...
On this page of the site you can watch the video online Understanding Locking in SQL Server - SQL Server Tutorial with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 13 April 2015, share the link with friends and acquaintances, this video has already been watched 103,929 times on youtube and it was liked by 743 viewers. Enjoy your viewing!