What does the PAD_INDEX parameter do when you cr

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

(Continued from previous question...)

What does the PAD_INDEX parameter do when you create an index in SQL Server 2005?

Answer: Determines if space is left at the intermediate pages of indexes.

Explanation: If PAD_INDEX is set to ON, then the fillfactor is used to determine how much space is left in the intermediate pages of an index. If set to OFF, then the intermediate pages are filled near their limit with space being left for at least one row.

(Continued on next question...)

Other Job Interview Questions

• What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?
• You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
• What does this WHERE clause evaluate to?
• What can tracer tokens measure in SQL Server 2005 transactional replication?
• What does this return?
• What does HAS_DBACCESS() do?
• What does the NULLIF function do?
• What is a primary key? What is a foreign key?
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• What will be the result of the last SELECT statement if you execute the T-SQL script below as a sysadmin
• More...