Explain what are the basic functions for master, msdb, model, tempdb databases?
How to bind a view to the schema of the underlying tables?
What is user-defined function?
What are the filtered indexes?
What are different types of raid configurations? : SQL Server Architecture
Explain acid?
How would you choose between a clustered and a non-clustered index?
Explain different types of lock modes in sql server 2000?
What is the purpose of update statistics and scope_identity() function?
How to create new tables with "create table" statements in ms sql server?
What is subquery? Explain the properties of a subquery?
How to enable tcp/ip protocol on a sql server?
What is the use of sign function?
Explain about integration services of Microsoft SQL server?
Introduction of rollup clause using sum and group by clause?