What is an identity?
What are out-of-range errors with date and time literals?
What is temporary table in sql server? Why we use temp table?
What is a unique key constraint?
Do you know what is a linked server in sql server?
What is transaction server auto commit?
What is indexing a document?
How to connect PK and FK?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is the user of Primary key?
What is difference between process and thread? Explain lazy writer funcationality.
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
Why people hate cursor?