What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How sql server enhances scalability of the database system?
What is partitioned view?
Define compound operators?
What are the filtered indexes?
Explain transaction server consistency?
What is it unwise to create wide clustered index keys?
Explain transaction server implicit?
Define inner join? Explain with an example?
Explain the difference between function and stored procedure?
Explain the architecture of ms sql reporting service?
What is lock escalation and what is its purpose?
Explain syntax for dropping triggers?
Explain datetimeoffset data type in sal server 2008?
What is buffer cash in sql server?