What is data compression?
How to copy the tables, schema and views from one sql server to another?
what is unique and xaml nonclustered index
Is it possible to create trigger on views?
What is user-defined inline table-valued function?
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?