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 the differences between lost updates and uncommitted dependencies?
How to handle error or exception in sql?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
How to integrate the ssrs reports in application?
What is the usage of sign function?
What is normalization? Describe its different types.
What do you understand by mirroring and mention the advantages of the mirroring?
What is an index in sql?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What have included columns when we talk about sql server indexing?
How do I save a stored procedure in sql server?
What is SQL Azure Fabric?
What is an example of a primary key?
What does indexation mean?
Explain what is log shipping?
