Wow.  Thanks Jason.  I seriously had no clue.  Like I said, my aim is to help, not collect accolades for a resume but that comment just made the last 20...

Be careful, now... sometimes the change is from a value to a NULL.

A different type of "pandemic" was recently launched.  The world will not be "normal" any more... they've recently launched "CoPilot" for O365.

Dumb Dumb me was looking at it in the opposite direction. Its 1AM and because the work computer is in the hallway next to my kids bedrooms I can't...

Cool!  What's the answer?

Crud... I knew the answer but clicked on the wrong bloody button. 🙁

Thanks, Jason.  I have to tell you, you've made my month.  I had no idea about that and I sometimes wonder to myself whether or not I accomplished my goal...

Here's the "formula" I've been using in production

FF

100 - Static or usually static.

99 - Usually, some form of ever-increasing keyed index that suffers no fragmentation, which also means no "ExpAnsive"...

Ya gotta be careful, though.  If you do the index maintenance incorrectly, you could be setting up the index to do massive page splits which will cost you dearly in...

If you want really good help, then see the article at the first link in my signature line below for one of many ways to provide example data in a...

Then pray that your data has no times in it because of the use of BETWEEN. 😉

The biggest downside would be that your "temporary solution" will become permanent.  You may also be in serious violation of the 3rd party license agreement if you take this kind...

Dear Friends,

Please advise why the Index rebuild and Update stats  jobs on one server consume lots of disk space after they run..I have to manually shrink the data file...

Thank you both for the feedback and the very kind words.

Heh... unfortunately, I know that problem all too well because some folks at...