What’s the fastest way to get a thousand records

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

(Continued from previous question...)

What’s the fastest way to get a thousand records into the database?

Just looking to hear that they’ve done some work to performance tune their queries. If they’re doing fully logged individual record inserts, one at a time, into a data warehouse-size system, we’re going to have problems down the road. (Yes, We have actually worked with a BI developer that did millions of individual inserts per night in full recovery mode and thought the performance was the database’s fault.)

Bonus points if they link back to the previous interview question and talk about whether or not they should disable constraints or referential integrity during data loads.

(Continued on next question...)

Other Job Interview Questions

• For Junior DBA’s - Do You Know The Primary Responsibility of a DBA?
• Oracle Apps DBAs - How would you know about which servers are running on a particular node ?
• Oracle Apps DBAs - What is “Custom TOP” in apps ?
• What third party database tools are your favorites?
• Hyper-V or VMWare?
• Why do You Want to be a DBA?
• What’s the fastest way to get a thousand records into the database?
• Why are you here?
• SQL Server - Explain when and how transactions should be used.
• What’s the Largest Database You’ve Worked With?
• More...