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,

---

How to define output parameters in stored procedures?

0 Answers  

---

List out some of the requirements to set up a sql server failover cluster?

0 Answers  

---

Define the one-to-one relationship while designing tables.

0 Answers  

---

Explain indexed views and partitioned view with their syntax.

0 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---

What is the default server name for sql server?

0 Answers  

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

Diffrence between DTS vs SSIS

2 Answers   IBM, Infosys,

---

How you can change a cross join into an inner join?

0 Answers  

---

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

1 Answers   Wipro,

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---