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,

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---

We need to perform what steps in the following order to work with a cursor?

0 Answers  

---

What is primary key and example?

0 Answers  

---

Is it possible to have clustered index on separate drive from original table location?

0 Answers  

---

---

Why is normalisation important?

0 Answers  

---

How to change the password of a login name in ms sql server?

0 Answers  

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What are the system database in sql server 2005?

0 Answers  

---

What are the various editions of sql server 2017 that are available in the market?

0 Answers  

---

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---

Tell me what do we need queues in sql service broker?

0 Answers  

---