InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Meaning Of Lock Escalation And Why/how To Stop This? |
|
Answer» understand that whole table WOULD be locked for the processing thenn this is better to use TABLOCK hint and get complete table BLOCKED. This is a nice way to avoid the wastage of sql server DB engine processing for lock escalation. Somewhere you MAY ALSO need to use TABLOCKX when you WANT an exclusive lock on the table in the query. understand that whole table would be locked for the processing thenn this is better to use TABLOCK hint and get complete table blocked. This is a nice way to avoid the wastage of sql server DB engine processing for lock escalation. Somewhere you may also need to use TABLOCKX when you want an exclusive lock on the table in the query. |
|