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

How to assign new column names in a view?

0 Answers  

What are orphan records?

0 Answers  

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  




What security features are available for stored procedure?

0 Answers  

What is Extended user-defined?

0 Answers  

How many null values we can have in a unique key field in sql server?

0 Answers  

What is the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

What command is used to rename the database?

0 Answers  

What is the recommended total size of your memory optimized tables?

0 Answers  

What is a Lock and let me know Different types of locks?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories