![A Primer on Stored Procs, Locks, Transaction Commits & Query Plans in Microsoft SQL Server | by Subha Ganapathi | Geek Culture | Medium A Primer on Stored Procs, Locks, Transaction Commits & Query Plans in Microsoft SQL Server | by Subha Ganapathi | Geek Culture | Medium](https://miro.medium.com/max/1400/1*fIxxcum8u3DyADh5Xw-4ag.png)
A Primer on Stored Procs, Locks, Transaction Commits & Query Plans in Microsoft SQL Server | by Subha Ganapathi | Geek Culture | Medium
![Locking in Microsoft SQL Server (Part 17) – Implementing Critical Section / Mutexes in T-SQL | About Sql Server Locking in Microsoft SQL Server (Part 17) – Implementing Critical Section / Mutexes in T-SQL | About Sql Server](http://aboutsqlserver.com/blog/2013/2013-05-08/pic01.png)
Locking in Microsoft SQL Server (Part 17) – Implementing Critical Section / Mutexes in T-SQL | About Sql Server
![sql server - Why does an index rebuild requires a Sch-M lock? - Database Administrators Stack Exchange sql server - Why does an index rebuild requires a Sch-M lock? - Database Administrators Stack Exchange](https://i.stack.imgur.com/YtAba.png)
sql server - Why does an index rebuild requires a Sch-M lock? - Database Administrators Stack Exchange
![Does Creating an Indexed View Require Exclusive Locks on an Underlying Table? - Brent Ozar Unlimited® Does Creating an Indexed View Require Exclusive Locks on an Underlying Table? - Brent Ozar Unlimited®](https://www.brentozar.com/wp-content/uploads/2020/09/Indexed-View-Locks.jpg)
Does Creating an Indexed View Require Exclusive Locks on an Underlying Table? - Brent Ozar Unlimited®
![Puzzling Lock Escalation Behaviour in a Partitioned Table | The results, if any, should be discarded... Puzzling Lock Escalation Behaviour in a Partitioned Table | The results, if any, should be discarded...](https://andyhogg.files.wordpress.com/2012/12/120912_1652_puzzlingloc1.png?w=380)
Puzzling Lock Escalation Behaviour in a Partitioned Table | The results, if any, should be discarded...
![sql server - SQL index option Allow row lock, Allow page lock, should be set on or off? Is that possible to create periodically updated index? - Stack Overflow sql server - SQL index option Allow row lock, Allow page lock, should be set on or off? Is that possible to create periodically updated index? - Stack Overflow](https://i.stack.imgur.com/CWLBF.png)