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
1052What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
1059
Explain the difference between cross join and full outer join?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are the types of user defined functions in sql server?
Explain about merge replications?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What are the different kinds of ssrs reports?
How do I open a .db file?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What are commonly used odbc functions in php?
What are different backups available in sql server?
What is the Disadvantage of indexed sequential file.
How do I edit a procedure in sql server?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Name three of the features managed by the surface area configuration tool? : sql server security