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

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

when you create a database how is it stored? : Sql server database administration

0 Answers  

What do you understand by integration services in sql server?

0 Answers  

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

0 Answers  

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  




What do you know about system database? : SQL Server Architecture

0 Answers  

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

What is BCNF? How is it better than 2NF & 3NF?

0 Answers   Essar,

How much memory that we are using in Logshipping Concept?

0 Answers  

What is transaction server implicit?

0 Answers  

How do database indexes work?

0 Answers  

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,

For more SQL Server Interview Questions Click Here
Categories