Sql Server, Query Optimization.
types of locks are: Shared locks — Allow multiple transactions to read a resource simultaneously but prevent any of them from writing to it. Exclusive locks — Prevent other transactions from acquiring any type of lock (shared or exclusive) on the resource. Exclusive locks are used when a