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 is an inner join?
What are logical database components? : SQL Server Architecture
Explain the properties of subqueries in sql server?
How to list all triggers in the database with sys.triggers in ms sql server?
Explain tablesample?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Explain about analysis services?
What is the meaning of sql server?
What is usually the first word in a sql query?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
Is sql server 2016 free?
What are some examples of schemas?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What does nvl stand for?