1. Avoid using VB for tasks different than printing integers from 1 to 10.

2. Try to exec using ADO and some script (javascript) to see timings. When comparing make sure...

Look at filegrowth options of database.

Try to switch to Recovery Model: Simple

Search for exotic query, which may automaticaly use tempdb.

Is there any reason to compare XML to CSV?

Write

<root><![CDATA[

..contents of your CSV file..

]]></root>

and you have XML file.

Yes, need to escape "]]>".

Yes, need to add some funcionality to...