[dba-SQLServer] Transactions

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



More information about the dba-SQLServer mailing list