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:
[ Ссылка ]
Ещё видео!