[dba-SQLServer] What's happening here

jwcolby jwcolby at colbyconsulting.com
Thu Nov 15 05:39:43 CST 2007


I am trying to copy data from a table in one db to a table in another db,
same server.  To move 100K records takes 5 seconds.  To move 400K records
takes 2 minutes and counting.  Why is 4 times as much data taking 30 (PLUS!)
times longer

John W. Colby
Colby Consulting
www.ColbyConsulting.com 




More information about the dba-SQLServer mailing list