sqlnaive (2/11/2014)
I'm facing an issue here. I have one procedure which inserts data in a table with the help of some joins in few tables. Now there are around 1000 records to be inserted as a result of execution of that procedure. But the problem is that it's inserting one recor at a time. I have updated the statistics of all the dependent tables. There is no index on the table where data getting inserted. What can be the issue ? It's taking almost an hour to insert 1000 records.
Have you tried to use other account to execute the SQL?
Have you tried to load all related data into other database and run again, take a look what happens?
it might be caused by database configuration.