When starting SQL Server 2005 from the command l

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

(Continued from previous question...)

When starting SQL Server 2005 from the command line, what does the -h switch do?

Answer
This switch reserves memory space for Hot-Add memory metadata, available with AWE enabled.
Explanation
This switch is used with 32-bit SQL Server and AWE to reserve memory to reserve memory space for Hot-Add memory metadata.

(Continued on next question...)

Other Job Interview Questions

• You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?
• How can you determine which Service Broker ports are being used on your server?
• Which framework would you use to manage this database programatically?
• True or false, Report Builder supports user defined run time parameters?
• Which of these is not a parameter you can pass to the LOGINPROPERTY function?
• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
• You have installed a US English SQL Server 2000 instance with the default options, collation, and sorting...
• What does the function ORIGINAL_LOGIN return in SQL Server 2005?
• You are looking to setup a large Notification Services application...
• More...