What is blocking and how would you troubleshoot it?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajendra kumar
Select Blocked from Master..sysprocesses Where Blocked <>0
| Is This Answer Correct ? | 0 Yes | 0 No |
What is purpose of normalization?
Explain about SQL server 2005?
How do I find the sql server instance name?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
How to enter unicode character string literals in ms sql server?
what kind of lan types do you know? : Sql server database administration
What the different types of Replication and why are they used?
What is the order in which the sql query is executed?
What is difference statement and preparedstatement?
How do you debug a procedure in sql server?
What is a group function explain with an example?
What are types of subqueries?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)