Hi Jeff,

We did this test to check the overall response time on high number of consecutively updates, which is similar to the pattern the table is used in production.

We thought that the semicolon at the end of each line will cause an implicit commit. Are we wrong in such an assumption?

What is the difference between running a 1000 update as in the first example and wrapping it in a transaction?

BY the way I checked the Implicit Transaction for both SQL server and my query sessions and it is OFF.

Thanks.