What is the difference between deallocate cursor and close cursor?
What is cursors?
How do you run a trace?
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?
What is data source in connection string?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
How to concatenate two strings in SQL Server.
What is raid? : SQL Server Architecture
What is change data capture (cdc) in sql server 2008?
How to round a numeric value to a specific precision?
Does a sql server 2005 select statement require a from?
What does it mean to normalize a database and why would you do it?
Explain the Ways to improve the performance of a sql azure database?
Explain what is use of dbcc commands?
List out what other servers you can use with ssrs?