We have sql server 2005 x64 on a server with win 2003 x64, dual core AMD 64 and 4 gb of memory. We are doing an EDI application. There is one parent table and about 70 related child tables which are being updated from a dot net 2005 dataset. We update the parent table with one record and a PK and then update the rest of the tables one at a time in a loop and then go back and do it again. The total records for the parent table in the data set is limited to 5000. The child tables may have anywhere from zero to 10000 records in the dataset. The insert performance is in the tank. What should we be doing differently? We are kind of new at this and any suggestions will be appreeciated.