You have noticed in both your SQL Server 2000 an

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

(Continued from previous question...)

You have noticed in both your SQL Server 2000 and 2005 instances that when a database grows in SQL Server, there is a delay in the database response. Why is that?

Answer
Once the file is grown, zeros are written to the new space, causing a delay.

Explanation
When a database file grows, unless instant file initialization is turned on, the server must allocate disk space and then write 0s into all that space. This zero-ing out of the file creates the delay.

(Continued on next question...)

Other Job Interview Questions

• 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 does the max full-text crawl range option do?
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• Does a root element in an XML document necessarily contain all the content for a well-formed document?
• In SQL Server 2005, what permissions does a user need to successfully execute the USE command?
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• Which of the queries is the best one for Janice to use to return the information she has been requested to provide?
• You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this?
• What result would you expect from this statement? Select * from dbo .MyTable
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• More...