List out a number of the wants to setup a SQL Server failover cluster?

0 Answers  

---

How to define output parameters in stored procedures?

0 Answers  

---

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

13 Answers   DELL,

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

---

Can we use pragma autonomous_transaction in trigger?

0 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  

---

When should you use an instead of trigger?

0 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

What is 2nf in normalization?

0 Answers  

---

Explain different types of Normalization.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

What's the purpose of Stored Procedure?

6 Answers   Wipro,

---