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 do we need queues in sql service broker?
What are dml (data manipulation language) statements in ms sql server?
Which are the important points to note when multilanguage data is stored in a table?
Differentiate between ms sql server reporting services vs crystal reports?
What is instead of dml trigger?
How to select some specific rows from a table in ms sql server?
What is data compression? : sql server database administration
Can you explain various data region available in ssrs with their use?
Difference between uniqe index and uniqe constraint?
What is onf in normalization form?
Can you force a query to use a specific index?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is statement level trigger?
What is the purpose of sql profiler in sql server?
What is rtm version in sql server?
