What are the steps you can take to avoid “deadlocks”?
No Answer is Posted For this Question
Be the First to Post Answer
What is oltp (online transaction processing)?
Where do you find the default Index fill factor and how to change it?
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?
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?
What is the difference between lock, block and deadlock? : sql server database administration
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?
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
Tell me what is the order in which the sql query is executed?
How will u get 5 years back record?
How to insert data into an existing table?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
how to know Who Is Blocking Your SQL Server?