Difference between uniqe index and uniqe constraint?
What are ddl triggers and types of ddl trigger?
How many non clustered indexes there can be on table ?
What are different types of subquery?
Explain few of the new features of sql server 2008 management studio
What are “lost updates”?
What command do we use to rename a db, a table and a column?
What is the difference between a function and a trigger?
What is t-sql script to take database offline – take database online.
What is a filestream?
What is difference between commit and rollback when used in transactions?
Data table as parameter in sql server?
What is the xml datatype?
What is the difference between index seek vs. Index scan?
What is set nocount on and what is set nocount off?