Explain what is lock escalation and what is its purpose?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  


Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,


What are the requirements to use odbc connections in php scripts?

0 Answers  


What is transaction server distributed transaction?

0 Answers  


Difference between Function and Procedure-in general?

6 Answers  






1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,


What is split brain scenario in DB mirroring?

1 Answers  


What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,


Explain intellisense for query editing

0 Answers  


Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,


How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,


What is user defined datatypes and when you should go for them?

0 Answers  


Categories