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
How do I view views in sql server?
What the different topologies in which replication can be configured?
What is tablix?
Does sql server 2016 have ssms?
Give me any three differences between Truncate and Delete.
What is the difference between push and pull subscription? : sql server replication
What does the not null constraint do?
What happens if strings are casted into wrong code pages in ms sql server?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
How do you debug a procedure in sql server?
What is the difference between local and global temporary tables?
What is the Disadvantage of indexed sequential file.
What is entity data services?
How to backup encryption key ?
What do you understand by integration services in sql server?
