"Before jumping into how things work, I'd like to go over two commands I'll be using a lot - DBCC PAGE and DBCC IND. Good article Jeff, and I did read Pauls blog on DBCC PAGE AND DBCC IND and Paul says the following about those undocumented commands: Its just an idea, I never tested it and cannot guarantee it runs into unforeseen problems either. What about making some sort of temporary Delta/Offset table first for those records that changed and then use this as input in a batch update that corrects all depending records with the appropriate offset without using a pseudo cursor. It is hard to argue with a 'may not work well' opinion, but I just want to state that I can think of a way that could in fact work well. In fact I think I still don't get the reason why one works and the other doesn't (and I would go 2 parts all the way because of this).Ģ) At the end when talking about a trigger method to keep a running total correct at all times, you state that it might not work well with batch updates. But I wouldn't be me if I had not at least some comments, so here they come:ġ) In Figure 28 I personally found the switch from the 3 part assignment problem, solved by using 2 part assignment, straight to a "this is the correct way" which shows 3 parts nfusing. Thank you for the very clear article and all the testing done to make sure that what you claim is 100% correct.
0 kommentar(er)
