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 is the Disadvantage of indexed sequential file.
According to you what goes into making the best database administrator? : sql server database administration
Write a program using SQL queries to find a unique entry in a table.
Explain boyce and codd normal form(bcnf)?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How would you go about developing a ssrs report?
Explain primary key, foreign key and unique key?
Can we use custom code in ssrs?
How to connect ms access to sql servers through odbc?
What is indexing a document?
How to use the inserted and deleted pseudo tables?
How is foreign key related to primary key?
Where is localdb stored?
Difference between report and query parameter. Why do we need different type of parameter?
