Interview Questions
1. What is Dynamic Locking?
Microsoft SQL Server Database Engine uses a dynamic locking strategy to determine the most cost-effective locks. The Database
Engine automatically determines what locks are most appropriate when the query is executed, based on the characteristics of
the schema and query. For example, to reduce the overhead of locking, the optimizer may choose page-level locks in an index
when performing an index scan.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment