What are the basic functions for master, msdb, model, tempdb databases?
Explain the concept of recursive stored procedure.
What do you mean by an execution plan? Why is it used? How would you view it?
What is dbcc? Give few examples.
What is row_number function?
What do you mean by an execution plan?
What is a trace frag? Where do we use it?
Explain use of expression builder.
What is use of except clause? How does it differ from not in clause?
What are cursors and when they are useful?
What is raid and what are different types of raid levels?
What do you understand by a view? What does the with check option clause for a view do?
Define views.
What is cte (common table expression)?
What do you mean by an execution plan? Why is it used?