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...

Keep it simple

DECLARE @sample TABLE
        (
             ...

Without having to look much at the code you posted, what is the unit value of the h.run_time column?

They do it in a lot of languages... I hate it when people number the bits differently than the exponent of "2".  😀

Imo it depends on whether or not Approved is exactly equivalent to Taken.  Could a user be officially approved and yet not take the day?  If there's...

Serious "chicken dinner" there for performance, Jonathan... here are the stats from a test on a million rows of 16 hex digits (8 bytes)...

 SQL Server Execution...