Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5185 Views
- HCL, I also Faced
- E-Mail Answers
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 |
How to test a dml trigger in ms sql server?
What is the difference between SSAS 2000 and SSAS 2005?
How can i Relate Tables in SSIS
how to avoid cursors? : Sql server database administration
What happens if null values are involved in arithmetic operations?
i need some interview questions on sql server developer plz any onee send some links.
What are examples of triggers?
What is the command dbcc checkdb used for?
Define compound operators?
Explain log shipping?
What is the use of set nocount on/off statement?
Explain what is lock escalation and what is its purpose?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
