What guidelines should be followed to help minimize deadlocks?
No Answer is Posted For this Question
Be the First to Post Answer
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Why do we use non clustered index?
How to execute stored procedure in select statement sql server?
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
Write a SQL command to insert and update only a particular field?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
Explain how does the report manager work in ssrs?
What is the difference between value type and reference type?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What do you mean by acid?