In SQL Server 2005 Integration Services, if you

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

(Continued from previous question...)

In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?

Answer
Fast Parse
Explanation
The fast parse mode that is set on columns for a flat file source connection can import a limited set of data types extremely quickly.

(Continued on next question...)

Other Job Interview Questions

• How can you ensure they do not change the underlying tables without also changing the view and not disrupt their workflow?
• If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• In the REPEATABLE READ isolation level, what phenomena is still possible?
• What is a bookmark lookup?
• Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?
• Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?
• You are building an application for a Smartphone and want to use SQL Server Compact Edition. However you do not want this to run as a service all the time because of power concerns. What can you do?
• Your SQL Server 2005 Express Edition locks up frequently and cannot be accessed. How can you enable the dedicated administrator connection?
• On which port does the dedicated administrator connection listen in SQL Server 2005?
• More...