What are the steps you can take to avoid “deadlocks”?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is oltp (online transaction processing)?

0 Answers  


Where do you find the default Index fill factor and how to change it?

0 Answers  


how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  


What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  






write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  


Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  


Tell me what is the order in which the sql query is executed?

0 Answers  


How will u get 5 years back record?

5 Answers  


How to insert data into an existing table?

0 Answers  


On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  


how to know Who Is Blocking Your SQL Server?

4 Answers  


Categories