Do you know what is normalization of database? What are its benefits?
Explain go command in sql server?
What is sql stored procedure?
What is blocking?
Do you know query execution plan?
Do you know what is sql service broker?
Explain what is the function of sql server agent windows service?
Explain what are various ways to enhance the ssrs report?
What is a linked server in sql server?
Do you know what is a trace frag? Where do we use it?
Explain what are sparse columns?
Explain differentiate between a having clause and a where clause?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
How many levels of sp nesting is possible?
Tell me what is de-normalization and what are some of the examples of it?