What are the advantages of log shipping?

0 Answers  

---

Is sql server free?

0 Answers  

---

How to rename an existing column with sql server management studio?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

---

what is spatial nonclustered index

0 Answers  

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

What is the difference between distinct clause and group by clause?

2 Answers   HHH, Value Labs,

---

What do you understand by check constraint in sql server?

0 Answers  

---

what is database replication? : Sql server database administration

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---