I agree that Temporal tables don't have an explicit marking for the action taken on a row for MS Temporal Tables.  It's really easy to determine, though...  (and you probably...

That's the same link that the Op provided in the original post on this thread. 😀

Ok... based on your last post above, especially the part where you say there's a "requirement to make multiple submissions at various milestones during the month", here's what I think. ...

Awesome.  Thank you for the feedback and welcome aboard!

I'll try to work on this tonight after work.  Thanks for the example.

I missed this.  Considering what they did to the FORMAT function for performance, have...

This looks like a prelude to spam.  Which problem of your did it fix and which of the many entries fixed it?

Ah... got it.  Now I know why the concern over milliseconds.  Thanks for the feedback.

One of the issues is, of course, not bumping up the CPU time with a utility...

Post deleted.  This thread did end up showing up in "active" threads.

@steve-2 Collins,

I also mean to say, GREAT question!

It's a good solution as long as you recognize that you're creating an internal  Cartesian product between rows in the table value constructor (tvc) and the rows in the...

Just in case someone comes across this again, I have a nice little update for all'ya'all. 😀

Step 1 is to create this function in your master database.  Details are, of...

This feels almost like an undocumented "feature" (similar to quirky updates)... I know I would be a bit hesitant in how I used this and would probably continue to...

Hi Michael.  Without going into my reason, I need to know the sum of CPU usage for ad-hoc batches of SQL statements I execute, on a per-database and per-time-window...

I'm almost out of "off the top of my head questions" but, just to be sure, are you taking DIF backups and mistakenly naming them BAK like your FULL backups...