What is blocking and how would you troubleshoot it?
Answer Posted / swapna
Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What does it mean to manipulate data?
What is cursor in ms sql server?
What is the beast way to write CTE in SQL Server ?
What is a trace frag? Where do we use it?
Can a rule be bound to any column of any data type?
What is the difference between a check constraint and a rule?
When we should use and scope of @@identity?
How to generate random numbers with the rand() function in ms sql server?
What are views in ms sql server?
What is the difference between getdate and sysdatetime?
What is a trigger? Why we need it?
what is a deadlock? : Sql server database administration
What is ddl command?
What is implicit cursors?
What is the difference between char, varchar and nvarchar?