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 inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is the difference between ‘having’ clause and a ‘where’ clause?
Is oracle faster than sql server?
What is excution Plan in sql server
1 Answers CarrizalSoft Technologies, TCS,
how to copy only distinct data into another table which is not already exist in database?
Can we passed multiple recordset(set of records) using a Stored Procedure
What is difference between rownum and row_number?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
Explain what are page splits? : SQL Server Architecture
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?
What is store procedure? How do they work? When do you use?
how do we find every fifth record in a table