What is deadlock and how to avoid the deadlocks.
Answer Posted / moin
A deadlock occurs when there is a cyclic dependency between
two or more threads for some set of resources.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What can be used instead of trigger?
What is local temp table?
How will you optimize a stored procedure optimization?
What objects does the fn_my_permissions function reports on? : sql server security
What is difference between primary key and foreign key?
What is amo? : sql server analysis services, ssas
How to use “drop” keyword in sql server and give an example?
How can you know if the row fetched from cursor is still valid in underlying table?
What is the difference between a unique key and primary key?
What command must you use to include the not null constraint after a table has already been created?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
what is raid and what are different types of raid configurations? : Sql server database administration
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What are the advantages of paper records?
What happens on checkpoint?