Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 2 Answers
- 5415 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 |
What is the purpose of self join?
What is simple indexing method?
Where do we generally create INDEX?
1 Answers Ernst Young, Thomson Reuters,
Define primary key?
What are the steps you should follow to start sql server in single-user mode?
Do you know the different ddl commands in sql?
What is update_statistics command?
Explain sql server service broker?
what are user defined datatypes? : Sql server database administration
What stored by the msdb? : sql server database administration
explain different types of backups avaialabe in sql server? : Sql server database administration
What are the magic tables in SQL Server 2000?
7 Answers Infogain, Merrill Lynch,
-
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)
