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,

---

What are “lost updates”?

0 Answers  

---

How to delete a login name in ms sql server?

0 Answers  

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

What are logical database components? : SQL Server Architecture

0 Answers  

---

---

What is de-normalization and when do you do it?

3 Answers  

---

Difference between rowid and rownum in SQL?

1 Answers   Virtusa,

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

---

What is the bookmark lookup and rid lookup?

0 Answers  

---

Define the term DML, DDL and DTL?

1 Answers  

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---