1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?

Question Posted / swapna


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is wri..

Answer / swapna

Instantiating COM objects is a time consuming process and
since you are doing it from within a trigger, it slows down
the data insertion process. Same is the case with sending
emails from triggers.

This scenario can be better implemented by logging all the
necessary data into a separate table, and have a job which
periodically checks this table and does the needful.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

query processing

0 Answers  

What is difference between materialized view and view?

0 Answers  

What is inline variable assignment?

0 Answers  

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

How do you delete duplicate records in sql server?

0 Answers  




How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

what is sql injection in sql server?

2 Answers   TATA,

What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

How we can refresh the view?

0 Answers  

What command do we use to rename a database?

0 Answers  

find the 3rd max salary

10 Answers  

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

For more SQL Server Interview Questions Click Here
Categories