Do you know concepts and capabilities of sql server?
Explain how to use linked server?
What do you mean by an execution plan? How would you view it?
Do you know what are acid properties of transaction?
Explain what is lock escalation?
Explain what are magic tables in sql server?
Tell me what are cursors and when they are useful?
Do you know what is a linked server in sql server?
Do you know what is difference between stored procedure and user defined function?
Tell me when is the update_statistics command used?
Explain the xml support sql server extends?
Explain the rules for designing files and file groups in sql server?
Do you know what is rank function?
Tell me what is normalization? Explain different forms of normalization?
Do you know what are acid properties?