What is self join in sql server joins?

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

How to find the source of a table in sql server?

0 Answers  

---

What do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---

What are cursors?

8 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

---