Grant Fritchey (8/5/2014)
"What's the difference between a deadlock, spelled d e a d l o c k, and a block, spelled b l o c k?" God I love that question. Most people carefully describe a block and then carefully describe a block.
I'll take a stab at this (mind that I am a lowly BI developer:-)).
Blocking is when one process has locked a resource and another cannot use that resource until the first process finishes. Usually resolves itself once the first process gives up the lock.
Deadlock is when two processes have acquired locks on two different object and before they can move on they need access to each others resources. They lock each other out and there is no resolution but to kill one of the processes.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP