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


Please Help Members By Posting Answers For Below Questions

How can you start sql server in different modes?

708


What are the events recorded in a transaction log?

729


How global temporary tables are represented and its scope?

714


What different steps will a sql server developer take to secure sql server?

718


Where are full-text indexes stored?

727






Which sql server table is used to hold the stored procedure scripts?

795


Can you explain different types of joins?

709


How to use values from other tables in update statements in ms sql server?

738


Can we linked SharePoint to a SQL database?

747


What are logical database components? : SQL Server Architecture

652


What language is sql server written in?

714


How network traffic be reduced by using the stored procedure?

770


What are cascading parameters in ssrs reports?

201


How to use group functions in the select clause in ms sql server?

710


How much space does sql server 2016 take?

726