I have a system that contains a very large amount of data around 200 Million rows and regally we need to add more data to this an extra 10 Million rows at a time is typical, now this works find but the overhead of this process takes it's toll on the server
as a whole so I was wondering if any one know if batch processing the insert would help.
I would be interested to know if this would reduce the demand on the server at any one time and therefor allowing other processes to run quicker
and what effect if any this would have on the overall time that the process takes.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.