Tag Archives: Deadlocks

Top 10 SQL Server Concurrency and Locking Interview Questions

Posted on December 12, 2016 by uday arumilli

Top 10 SQL Server Concurrency and Locking Interview Questions SQL THE ONE There are total 51 questions are answered under SQL Server Concurrency and Locking category in the book “SQL THE ONE”. In this chapter we can see questions and … Continue reading →

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , | Leave a comment

MSSQL Concurrency Control and Locking – MSSQL Interview questions with answers

Posted on October 29, 2014 by uday arumilli

Concurrency Control And Locking SQL Server Concurrency Control 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 Data R1 … Continue reading →

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