Tell me the phases a transaction has to undergo?
What is the difference between clustered and non-clustered indexes in ms sql server?
Is it possible to have clustered index on separate drive from original table location?
What does it mean to normalize a database and why would you do it?
Which command displays the SQL command in the SQL buffer, and then executes it?
Do you know clustered and non-clustered index?
Diffrences between sql server 2000 vs 2005
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?
Explain boyce and codd normal form(bcnf)?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is a trigger?
How do I start sql server?
What are extended events in sql server?