February 2, 2009 at 9:43 am
update dbo.table1 set
col1 = some_value;
update dbo.table2 set
col1 = another_value;
update dbo.table3 set
col1 = and-another_value;
The three updates above will run one after the other (serialized).
If I put each of the updates in separate windows and run, they would run in parallel.
February 2, 2009 at 9:47 am
Yes but iwould like to know if they queries run in parallel will that degrade performance
February 2, 2009 at 9:50 am
Confused I am. Your original question stated that developers currently run multiple windows resulting in the CPU jumping to 100%. If they serialize those updates, it should help.
February 19, 2009 at 12:43 pm
I tried the above query today for my updates and it updated few million records, thenumber which i was looking to update but after the query is not stopped, is this something like infinite loop problem.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply