Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
1053Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
1051What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
1059
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is public role in sql server?
How self join is different from outer join?
what data regions are and what are the different data regions?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How can you find out how many rows returned in a cursor?
What are distinctive joins find as a part of sql?
How to create a dml trigger using create trigger statements?
Which are new data types introduced in sql server 2008?
What do you understand by hotfixes and patches in sql server?
Explain the dbcc pintable command when would you use it?
How can we rewrite sub-queries into simple select statements or with joins?
What are the steps you can take to avoid “deadlocks”?
What is the sql server agent?
What is dbcc command in sql server?