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 is the difference between for xml raw and for xml auto?
What are .mdf files?
How many instances per computer are there in sql server 2000?
How to select an exiting database using mssql_select_db()?
In what sequence sql statement is processed?
How to delete existing triggers using "drop trigger"?
Can you name a few encryption mechanisms in sql server?
What is the sql case statement used for?
How to generate create procedure script on an existing stored procedure?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What is the maximum size of column in sql server?
What is 2nf in normalization?
How can you hide the sql server instances?
List the data types available in mssql?
Explain what are the database objects? : SQL Server Architecture