Jan Arnoldus (8/24/2013)What is the difference between running a 1000 update as in the first example and wrapping it in a transaction?
In the first case, each statement commits separately, and the log record must be flushed to the transaction log on disk before execution can continue. In the second case, the log records do not have to be flushed until the entire transaction commits.
By the way, the semicolons has nothing to with it. They are just syntax.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]