Explain about system stored procedure?
Explain about remote stored procedure?
Explain candidate key, alternate key, and composite key?
Tell me about normalization in DBMS.
What is ACID Property of Transaction?
What is indexing and its types?
How to bind a view to the schema of the underlying tables?
Do you know what is a with(nolock)?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain few of the new features of sql server 2008 management studio
Explain what are the different index configurations a table can have?
Will the writetext statement activate a trigger?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?