what is a correlated sub-query? : Sql server database administration

0 Answers  

---

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

---

What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

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  

---

What is optimization and its types?

0 Answers  

---

what are batch in sql server?

2 Answers   Satyam,

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

How you can change the database name in SQL SERVER?

0 Answers  

---

What is difference between equi join and natural join?

0 Answers  

---

What the different components of Replication and what is their use?

0 Answers  

---