Answer Posted / guest
When a table is accessed by more than one user than that
table may get locked for some particular user and holding
others untill the lock get released, in such scenario the
deadlocks get generated and the query for others executing
that table get stuck.This may lead to the hanging of the
application.
The deadlocks can be overcome by,
Not using order by and group by clause or by index
rebuilding and proper indexing.
The deadlock cannot be permanently avoided
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
How to configure odbc dsn with different port numbers?
Explain comment on transactions?
Explain what is dbcc?
How can a database be repaired?
How to receive returning result from a query?
What is after dml trigger?
Does sql server 2000 full-text search support clustering?
Explain the various types of concurrency problem?
What are tables in sql server?
How to insert multiple rows with one insert statement in ms sql server?
What are the different methods available under sqlcommand class to access the data?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is the difference between a fill factor of 100 and 0?
What are distinctive joins find as a part of sql?
