jwcolby
jwcolby at colbyconsulting.com
Tue Oct 6 16:34:40 CDT 2009
Is it possible to tell SQL Server to use transactions inside of a single query? I routinely do things like update a single field for 50 million records. It might be beneficial to be able to tell SQL Server to commit the updates every N million records. I have no idea whether it is possible, or if it is what the results would be but I thought it worth asking the question. Can it be done? Would it make any difference. -- John W. Colby www.ColbyConsulting.com