Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
when inserting to a table how many rows will be effected using triggers
What are database states in ms sql server?
What is meant by indexing files?
Explain transaction server isolation?
How to find the date and time of last updated table?
Define full outer join in sql server joins?
can we call functions from stored procedure in SQL Server 2005 ? How?
What is query optimization process?
How can I tell if sql server is 32 or 64 bit?
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?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 Answers Accenture, Merrill Lynch, Wipro,