Interview Questions
1. Explain a SQL Server deadlock
A deadlock is a situation where 2 spids have data locked and cannot release their lock until the opposing spid releases their
lock. Depending on the severity of the dead lock, meaning the amount of data that is locked and the number of spids that are
trying to access the same data, an entire chain of spids can have locks and cause a number of deadlocks, resulting in a
performance issue.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment