Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 2 Answers
- 5530 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 are the different types of sub-queries?
What is reference section?
Which is faster statement or preparedstatement?
To find second largest salary in Employee table
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Explain the dbcc pintable command when would you use it?
How the data stores in a page?
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?
15 Answers Leo Technologies, Mannar Company, Synechron,
What is the system function to get the current user's user id?
What action plan is preferred if sql server is not responding?
What is split brain scenario in DB mirroring?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
-
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)
