I would like to update this answer of mine to add some new information. (I realized that when "walking the clustered index" of a table that has a multi-column clustered index, in most cases a great simplification can be achieved by using
WITH TIES in the update statement to enable working only with the first column of the clustered index. I'd also like to change a couple of other minor things.)
However, if I make this update, I'll hit 10 updates, and the answer will get converted to community wiki. I hate asking moderators to remove community wiki status--it seems like a waste of their time. At the same time, it bugs me that my answer is not as good as it could be! And yes, it bugs me to lose the reputation if it goes community wiki.
Note that I am doing my best to make more substantial edits and fewer trivial ones, so I don't run into this limit as often. But it does happen sometimes. You can look at the answer history to see if you think that my 8 edits were excessive or not.
- Avoid making the edit,
- Make the edit in pursuit of having the best answer and just take my lumps so I don't inconvenience moderators,
- Or make the edit and flag for a moderator as it's not that big a deal for them?