On which platforms can you use Instant File Init

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

(Continued from previous question...)

On which platforms can you use Instant File Initialization to improve database growth performance in SQL Server 2005?

Answer
Windows 2003 and XP Pro

Explanation
Both Windows 2003 Server and later as well as Windows XP Professional support Instant File Initialization.

(Continued on next question...)

Other Job Interview Questions

• How many Service Packs will be released for SQL Server 2005 in 2007?
• What does the sqlwb utility do?
• You cannot remember what permissions that the db_accessadmin fixed database role has ...
• What algorithm is used to encrypt the Database Master Key when it is created?
• How is Thesaurus data configured in SQL Server 2005 Full-Text Search?
• When using the SQLCMD tool, what does the -V parameter do?
• What port do you need to open on your server firewall to enable named pipes connections?
• In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?
• What is the quickest way to get them working?
• How many credentials can one login be mapped to?
• More...