Hi Mike.

Sorry, but yes you are correct the file paths in my example are not identical. I did a bad job of editing them. They should be :-

exec master.sys.xp_dirtree '\\servername\Users\SQLAdmin\Documents\BulkInsert\',...

Thanks Brian, I am aware of the downside to adding indexes. I will be monitoring these and removing any that are not being used. At the moment, I think the...

Thanks alot guys, I think I've taken a bit from each of the 3 posts and have made progress. I've posted the new execution plan below. Seems to be consistently...

• This reply was modified 10 months, 2 weeks ago by  MrBen.

Hi Brian.

Yes, you are correct in that it's a stored procedure. It needs to be run for about 1000 companies either seems to take about 3 hours or 20 hours...

Thanks Brian.

I suppose what I'm really trying to see is does SQL Server have enough memory. The server is experiencing periodic performance problems and I'm wondering if more memory will...

Thanks Grant.

And where are these transactions held? Within the transaction log presumably? If so, do the transaction log backups that have been done not have an effect ?

Assuming the above...