Follow Up
A reader, May 19, 2020 - 6:38 pm UTC
Ok. Thanks for the response.
I thought these delete statements would fragment the table because insert/delete every two weeks.
Having said that, it is very unlikely that what you are doing it going to cause a fragmentation issue. What did you mean with this?
Regards,
May 20, 2020 - 2:27 am UTC
Fragmentation with deletes *can* occur, but in specific instances (as detailed in Richard's whitepaper).
The most typical deletes are "delete old, insert new" style operations....which is not one of those specific instances.
Review
A reader, May 20, 2020 - 3:54 am UTC
Ok. I got it.
Thanks,.