explain different types of backups avaialabe in sql server? : Sql server database administration
What is the cartesian product of table?
What are the steps you should follow to start sql server in single-user mode?
What is view in sql?
How to create a view with data from multiple tables?
What is tempdb in sql server?
How to create user defined functions with parameters?
What is history table in sql server?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is a partitioned view?
explain different types of constraints? : Sql server database administration
Which tcp/ip port does sql server run on? How can it be changed?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?