A deadlock occurs when there is a cyclic dependency between two or more t

What is deadlock and how to avoid the deadlocks.

Question Posted / moin

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

Please Help Members By Posting Answers For Below Questions

Can I delete event logs?

911

How would you go about developing a ssrs report?

164

What is the rdl file?

138

What is similarity and difference between truncate and delete in sql?

1075

what is a check constraint?

1073

What is sqlservr.exe - process - sql server (sqlex?press)?

1084

How exceptions can be handled in sql server programming?

990

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1045

What is difference between foreign key and unique key?

994

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1115

What is master database? : SQL Server Architecture

996

How do you manipulate data?

885

State the difference between union and union all?

915

Can group by be used without aggregate functions?

894

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

885