Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 2 Answers
- 5628 Views
- I also Faced
- E-Mail Answers
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 |
Explain triggers?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is constraints and its types?
What do you understand by a view?
what is a cursor and what is its use?
How to add code to the existing article (using improve article)?
What is a non clustered primary key?
How to tune a stored procedure?
What is deploy, process and build? : sql server analysis services, ssas
Why normalization is used?
What are the pre-defined functions in the sql server?
What is difference between materialized view and view?
-
Oracle (3253) - 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)
