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
what type of index will get created after executing the above statement? : Sql server database administration
mention different types of relationships in the dbms?
What are data resources?
Can you create a logon trigger in sql server 2005 express edition?
Why we use functions in sql server?
Which sql server table is used to hold the stored procedure script?
What is the difference between char, varchar and nvarchar?
What is a matrix in ssrs?
Why use identity in sql server?
Explain system scalar functions?
How much is a sql server license?
What is the purpose of floor function?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is the importance of a recovery model?
What is abstracting periodical?