What are basics of policy management?
State the difference between union and union all?
What happens if null values are involved in string operations?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Explain intellisense for query editing
Is foreign key unique?
What is the tcp/ip port on which sql server runs?
What is spid in sql server profiler?
What is the use of MOVE keyword in restore command
What is forward - only cursors / read only cursor?
Difference between aggregate functions of sql?
What is truncate table?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?