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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
how you can move data or databases between servers and databases in sql server? : Sql server administration
How to create function with parameter in sql server?
Explain system functions or built-in functions? What are different types of system functions?
what is unique and xaml nonclustered index
What are the differences between web role and worker role?
What is optimization and its types?
Why are views required in the sql server or in any other database?
What is difference between index seek vs. Index scan?
How optimize sql query with multiple joins in sql server?
What is the difference between index seek vs. Index scan?
Explain can SSRS reports Cache results?
What is TDS(Tabular Data Stream) Gateway?
How do I delete a sql server database?
Where can you find the error log information? : sql server database administration