What is blocking and how would you troubleshoot it?
- 2 Answers
- 4933 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 user defined views?
What are the types of dml?
What is for xml in sql server?
What is the Main Difference between ACCESS and SQL SERVER?
What is the difference between a primary key and a unique key? Are they the same?
How to retrieve error messages using mssql_get_last_message()?
create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year
What's the difference between a primary key and a unique key?
Can a database be shrunk to 0 bytes, if not, why?
what is the Enterprise manager(2000) and management studio (2005)?
Explain the concept of view and Types of views in SQL server?
Tell me about Triggers?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
