What is an Index in MS SQL Server?

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

(Continued from previous question...)

What is an Index in MS SQL Server?

An Index in MS SQL Server is an object associated to a table to maintain a sorting order of specified columns to improve query performance.

(Continued on next question...)

Other Job Interview Questions

• What can you do with the "BULK INSERT" T-SQL command in MS SQL Server?
• What can you do with the "ALTER DATABASE ..." T-SQL command?
• What does RDBMS stand for?
• Is it secure to use Windows Authentication to establish a connection to MS SQL Server?
• What can you do with the "ALTER DATABASE ..." T-SQL command?
• What does Extend refer to in MS SQL Server?
• What is the size a Page in MS SQL Server?
• What is the meaning of the following T-SQL command: "GRANT CREATE TABLE TO <username>"
• What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
• What is a simple way to detach a database that is not in use in MS SQL Server?
• More...