Explain nested join?
What is simple indexing method?
What is a NOLOCK?
What is difference between clustered and non clustered index?
What is deadlock and how to avoid the deadlocks.
How to find index size for each index on table?
What is right outer join in sql server joins?
What is the use of toad or sqldbx.?
What is normalization and its forms?
4 Answers Challenger Financial,
Explain the different types of backups available in sql server? : sql server database administration
What is indexed view?
What type of Index will get created after executing the above statement?
What are the steps you will take to improve the performance of a poor performing query?