I think that you'll find the same problems in SQL Server 2005 as well. SQL Server is designed to work off sets of data. Row by row processing is terribly inefficient, slow, and resource intensive. For the example you gave, why do you feel you need to insert the rows one at a time? If you've already imported from csv into a table, why can't you do your INSERT as a set based transaction?