This is easy then... have a video meeting where you drive and they tell you...

Thanks for the response, Greg.   I appreciate it.

I wasn't asking if anyone knew of an article that proves the "benefits" of doing Index Maintenance to figure out a way to...

He also was only testing a...

And, then again, NOT!  It turns out that he was testing fragmentation on spinning rust.  Not logical fragmentation of a index.  [headdesk] 🙁

BWAAA-HAAA-HAAA.  Posting on this thread must cause disturbances in the "force".  I looked again right after I posted and I finally found one.

https://gertjans.home.xs4all.nl/sql/fragmentation-hurts-performance.html

There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.

Other than...

Hi, excellent post, I have taken it and put it into practice, and it works very well for me to redo the whole nested set, But I want to...

I could be wrong but that looks like it will do a full scan of the table for each grouping of rows.  Why not just do a single pass with...

Lordy... and people wonder why their systems get hacked. 🙁

@ Venugopal Saride,

I have to say that is IS a very interesting way to try to do this but I have to agree with Eirikur...  It doesn't meet the promises...

@ Jonathan, Ken, and Steve,

Thank all 3 of you for lending and ear and basically confirming that this is actually a real booger of a problem.  I really appreciate it,...

@ Steve Collins ,

Agreed and, except for RBAR or "Quirky Update" solutions, I'm not seeing a way to do this.  This is also kind of like the "Bin Fill" problem. ...

@ Peter Larsson...

You've been popping up on some of the formula related posts that I've posted to and you're listed as a "follower".  Any ideas/solutions here?

@ken McKelvey.  Thanks for looking and thanks for the confirmation in a couple of areas, here, Ken.

I've seen some mathematical magic in the past with "Gaps and Islands", which this...

p.s.  Your "Group 2" is incorrect according to the requirements.  Just to be sure, they're based on WHOLE days and the date span must be 5 days or less based...