what is Archive old data?
What are the different ways of moving data/databases between servers and databases in SQL Server?
What are the basic features of a trigger in ms sql server?
Explain the first normal form(1nf)?
What are various aggregate functions that are available?
How do you simulate a deadlock for testing purposes
What is Covering Indexes? Plz explain with example
What are the different types of replication? How are they used?
Do you know what is user defined datatypes and when you should go for them?
how to find number of columns in a table in sql server 2000 and 2005 also
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is optimistic concurrency?
what is a correlated sub-query? : Sql server database administration