pretea (3/13/2014)
Hi!I have multiple (individual) insert statement to insert around 2 million rows (using sqlcmd because the insert stament is around 8 thou lines).
It took about an hr to insert when I tried it on my machine which is physical server with 4 GB RAM.
When I try to run the same on my test server which is virtual machine it is still running,we have bumped up memory from 2 to 4 GB RAM.
Any suggestions?
Why is the insert statement around 8 thousand lines?
--Jeff Moden
Change is inevitable... Change for the better is not.