What does Extend refer to in MS SQL Server?

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

(Continued from previous question...)

What does Extend refer to in MS SQL Server?

Extend in MS SQL Server refers to a unit of storage. 1 Extend is 8 Pages.

(Continued on next question...)

Other Job Interview Questions

• When "SET CONCAT_NULL_YIELDS_NULL ON", concatenating a null value with a string will yield a NULL result. But this only applies to the current session if you use in Query Analyzer. Is this true?
• Where are database files and backup files of a MS SQL Server database located?
• What is the minimum of hard disk space required by MS SQL Server?
• What is the different between concurrent connections and concurrent user logins?
• What is "bcp"?
• What is the meaning of the following T-SQL command: DBCC SHRINKDATABASE ( Database, 10%)
• What can you do with the Bulk Copy operation in MS SQL Server?
• What is "bcp"?
• What should you do to prepare for MS SQL Server upgrade?
• What does Constraint refer to in MS SQL Server?
• More...