What are the disadvantages of using the stored procedures?

0 Answers  

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

Explain about link server in sql server?

0 Answers  

---

What is coalesce in sql server?

0 Answers  

---

What are different types of views?

0 Answers  

---

---

How to disconnect from a sql server using mssql_close()?

0 Answers  

---

What is ms sql server service broker?

0 Answers  

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---

What are the different Topologies in which Replication can be configured?

0 Answers  

---

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---