What protocol does sql server use?
How many database files are there in sql server 2000?what are they?
What is difference between delete and truncate commands?
How optimize sql query with multiple joins in sql server?
What is the use of =,==,=== operators?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
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?
How to create a new table in a given schema?
What is "scheduled jobs" or "scheduled tasks"?
Which language is supported by sql server?
Explain nested join?
What are the new security features added in sql server 2012? : sql server security
Why are views required in the sql server or in any other database?