Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are out-of-range errors with date and time literals?
How to provide login information for a new odbc dsn?
How to change server name in sql server?
How to generate create view script on an existing view?
Tell me what do you understand by a view? What does the with check option clause for a view do?
How do indexes help, types?
How many databases can we create in a single server?
Explain different types of lock modes in sql server 2000?
define and explain the differences between clustered and non-clustered indexes.
What is acid properties?
How does a profiler work?
What is subquery in sql?
How many levels of sp nesting are possible?
What are the differences between ms sql server & oracle?
When a primary key constraint is included in a table, what other constraints does this imply?
