Heh,... thanks for the feedback, Steve.  It was a story that explained that if you "know the gazintas, anything is possible"... even in SQL.  And, it was actually really simple...

I disagree with "stop rebuilding indexes." The quote you provided doesn't seem to support that statement if I take it as is, no caveats.

Regardless, we already have regular checkups...

For Minimal Logging on a Table with a Clustered Index.  Note that at least one of these is missing from the documentation but absolutely required to make Minimal Logging work.

...

I would like to have a 4 day Thanksgiving weekend where no one needed help doing something.

If the symbol and trade_date form a unique pair in the entire table, make that combination the Clustered Primary Key.  Leave this clustered index on the table at all times......

GENERATE_SERIES() has a "little" problem for me.  I generate shedloads of test data and the following problem means that I'll not be giving up the fnTally function any time soon...

Crud.  I just did a code review where this happened and forgot about it when I answered here. 🙁

And great question, BTW!

People seem to be missing the point here.  The simple fact is that it...

I posted a take at the following...

Stop rebuilding indexes.

Microsoft's documentation states:

Index maintenance decisions should be made after considering multiple factors in the specific context of each workload, including the resource cost of maintenance. They should...

You bet.  I hope that's one thing that they'll never change.

In SSMS, you have a choice of displaying...

Thank you! I was reading about the CE possibly being the problem. I did check some of the queries and they were individually set to CE to 70. I...

Since you say the updates are not "extremely frequent", it's mostly an "Insert" index by TenantID.  It's a Type 98 Index and since there aren't a large number of ExpAnsive...

Yes.  And...