How except clause is differs from not in clause?

0 Answers  

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

---

What is the use of sql profiler in sql server 2012?

0 Answers  

---

Explain about merge replications?

0 Answers  

---

Why variables called the most powerful component of ssis?

0 Answers  

---

Tell me what is log shipping?

0 Answers  

---

wat new abt truncate in sql server

2 Answers   HCL, HP,

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

How to restore performance issues and how to check?

0 Answers  

---