Tag Archives: Capture Deadlock information

MSSQL Concurrency Control and Locking – MSSQL Interview questions with answers

Concurrency Control And Locking Sql Server Performance Tuning Interview Questions Concurrency and Locking – Interview Questions with answers 1. What are the concurrent problems occur in accessing database? Ans: Tr – Transaction R – Resource Uncommitted dependency/dirty reads: Tr1 Updates … Continue reading

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , | 1 Comment