Thank you all for getting back to me. I appreciate the advice. Because of your advice, I won't make a big deal out of removing the ID. Oddly, I...

That's the same reaction I had when the size charts gave me a hint about what was...

Bumping my own post because of the 2nd page issue on this forum.

Sorry and done.

It's free.  Like it says in the presentation, send me an email to the email address I provided and I'll send you the zip file that I give folks when...

Heh... "It's Shake'n'Bake and I helped"! 😀

Welcome but, if you're going to say something like that, you should explain why...

Happy Thanks Giving to you as well, Rick and to all the denizens of SSC.

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!