![]() It's highly unlikely that it was clashing with another transaction, as the system was brought down for the update. Any thoughts or ideas would be appreciated. I ran it on another database where the number of rows is smaller (~20m)and it ran just fine. INNER JOIN RealTable ON RealTable.PrimaryKeyID = #Update.PrimaryKeyID I_ID int PRIMARY KEY NOT NULL IDENTITY(1,1), ![]() Here is the pseudo code: BEGIN TRANSACTION ![]() Tried to run the script two times now, the first time it broke after updating roughly 17m rows, the second time it stopped at 14m.Įrror message: Msg 1222, Level 16, State 43, Line 122 The updated is broken in batches, with checkpoints to allow clearing the transaction log. ![]() ![]() I'm running long bulk update script which is updating ~50m records. I tried to find something similar, but couldn't so decided to ask directly. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |