Do you know 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?
Alternative way to DetDate() function?
List the types of recovery model available in sql server?
What is difference between equi join and natural join?
how can a database be repaired? : Sql server administration
Call by value and call by reference in procedure and function, with NOCOPY.
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
What is the recovery model?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How connect excel to sql server?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Can sql servers link to other servers like oracle?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration