1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

What's the purpose of Stored Procedure?

6 Answers   Wipro,

---

Normalization and denormalization

3 Answers   Wipro,

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

---

Difference between sql server 2000 and sql server 2005?

11 Answers   Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

---

Explain what is sql server english query?

0 Answers  

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

---

What the different types of Replication and why are they used?

0 Answers  

---

What is the xml datatype?

0 Answers  

---

Explain sql server service broker?

0 Answers  

---