What are the new features introduced in SQL Serv

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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?

This question is generally asked to see how current is your knowledge. Generally there is a section in the beginning of the books online titled "What’s New", which has all such information. Of course, reading just that is not enough, you should have tried those things to better answer the questions. Also check out the section titled "Backward Compatibility" in books online which talks about the changes that have taken place in the new version.

(Continued on next question...)

Other Job Interview Questions

• What is a self join? Explain it with an example.
• What type of Index will get created after executing the above statement?
• What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
• What’s the maximum size of a row?
• What is database replication? What are the different types of replication you can set up in SQL Server?
• Can you have a nested transaction?
• What are the steps you will take, if you are tasked with securing an SQL Server?
• What is a transaction and what are ACID properties?
• How do you test proper TCP/IP configuration Windows machine?
• What's SQL Server
• More...