⟩ Explain what is lock escalation?
Lock escalation from SQL Server 7.0 onwards, is dynamically managed by SQL Server. It is the process of converting a lot of low level locks into higher level locks..
Question and Answer:
Home Basic SQL Server
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Explain the disadvantages of cursors?
How to avoid cursors?
Explain the cursor lock types?
Explain Temporary table VS Table variable by using Cursor alternative?
What is scrollable cursor?
Do you know the capabilities of Cursors?
Explain the ways to controlling Cursor Behavior?
MS SQL Server Functions Job Interview Questions!
Explain the benefits of User-Defined Functions?
What is user-defined function? Explain its types i.e. scalar and Inline table value user-defined function?
