Hi, This has been driving me nuts for a few days now. I'm more a developer than DBA, but the answer I suspect lies in the Server configuration. Apologies for the length of this, but I have tried a lot of things. Scenario : We get a monthly database dump in the form of a 1.5Gb csv file, comma delimited...

Hi, Their may be many reason, please check: * do you have clustered index on identity/incrementing datetime column on a table which has heavy transaction ratio then others * does this happen on particular table, what is the size of the index and table * do you have trigger on the table for insert * does...