What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

What are the main sources of data?

0 Answers  

---

What are the characteristics of modern DBMS?

0 Answers   Ericsson,

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

Explain aggregate functions?

0 Answers  

---