Tag Archives: Deadlocks

Top 10 SQL Server Concurrency and Locking Interview Questions

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

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