So post it.

It's not...

My favorite "Edge Case" is in the conversion of a DATETIME2 with a given resolution to a DATETIME2 of lower resolution or even DATETIME.  When is it "OK" for the...

It would appear that most of the code has simply been stolen from the following article...

https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/

Lordy... I missed your post above, Ron.  Great tip.  Thanks for posting it and sorry for it taking me nearly two years to acknowledge it.

To add to your good information,...

Gosh... SQL Server, MySQL, PostgreSQL, and (finally after decades of not) even Oracle has the ability to do JOINed updates.  Consider resubmitting this article with that critical functionality so that...

Nah... "AI" is the perfect abbreviation but people need to be aware of what it really stands for......

This sounds like a good place for monthly partitions.  The monthly switch out takes nearly zero time or resources and then the switched out part can just be dropped as...

Seems to me that the online documentation should be a better help for you.

Apologies for not knowing but what does "IAC" stand for in this context?

In my quick look at your article this morning, I may have missed it... are you using the paid version for ChatGPT?

I love how people tip-toe around this subject.  Oh... it's not going to eliminate DBA jobs... we'll just be able to get along with 3 people instead of 5 to...

If you're going to start talking about Random GUIDs (uniqueIdentifier type not using NEWSEQUENTIALIUD()), then you absolutely MUST watch the following video, which proves that what most people think they...

I wonder what the "compute cost" of these new functions is?

Thanks for your comments. I understand your points and I would like to clarify a couple of things.

Regarding the execution time difference, batch updates are faster because they reduce...