Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 2 Answers
- 5423 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 a result set object returned by mssql_query()?
Where the sql logs gets stored? : sql server database administration
I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.
in how many ways we can use count()
Write a sql query to sort on different column name according to the parameters passed in the function?
What are the advantages of mirroring?
Can we use having clause without group by?
What is the need for indexing?
What is difference between group by and having?
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
In clustered and non clustered indexes which one is faster while executing a query ?
What is explicit cursors?
-
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)
