29 questions for “Isolation & Locking”

Found in 1 field. Select a question to see its full answer.

Matching topics

SQL Server Isolation & Locking 7

Information Technology

29 questions in 1 technology

#QuestionTechnologyTopicLevel
1What are the four standard transaction isolation levels in SQL Server, and what does isolation level actually control? SQL Server › Isolation & LockingSQL ServerIsolation & LockingBeginner
2What is the difference between an optimistic and a pessimistic approach to handling concurrency, and where does SQL Server's snapshot isolation fit into this? SQL Server › Isolation & LockingSQL ServerIsolation & LockingIntermediate
3How would you diagnose and resolve a blocking problem where many queries are waiting on a single long running transaction? SQL Server › Isolation & LockingSQL ServerIsolation & LockingAdvanced
4How does Read Committed Snapshot Isolation differ from regular Read Committed isolation, and what tradeoff does enabling it introduce? SQL Server › Isolation & LockingSQL ServerIsolation & LockingAdvanced
5What is a lock in SQL Server, and why does the database engine use locks? SQL Server › Isolation & LockingSQL ServerIsolation & LockingBeginner
6What is a deadlock, and how does SQL Server automatically handle one when it occurs? SQL Server › Isolation & LockingSQL ServerIsolation & LockingIntermediate
7What are lock escalation and its potential impact on a busy system? SQL Server › Isolation & LockingSQL ServerIsolation & LockingIntermediate
8What is the difference between a deadlock and normal blocking, and how do you tell them apart when troubleshooting a slow application? SQL Server › DeadlocksSQL ServerDeadlocksIntermediate
9What is In-Memory OLTP in SQL Server, and what performance benefit does it provide? SQL Server › In-Memory OLTP (Memory-Optimized Tables)SQL ServerIn-Memory OLTP (Memory-Optimized Tables)Beginner
10What is a transaction in SQL Server, and why is grouping multiple statements into one important? SQL Server › Transactions & ACIDSQL ServerTransactions & ACIDBeginner
Show all 29 questions in Information Technology