The question is asked clearly: "What is the limit for rows in a Table Valued Constructor?". The documentation states that there is a limit. So there is nothing...

Oh, I...

Perhaps the documentation? 😉  https://www.postgresql.org/docs/current/indexes.html

Not a clue on your last question but I'd be loath to let anything create a permanent table in TempDB.  What do you suppose might happen on your next server...

I was right about price but, lordy... date and available are actually the TEXT datatype?  Even if they're VARCHAR() is a...

Thanks for the feedback, BOR15K.

Oh, I get that. ...

This ol' man learned something new today thanks to the replies above.  Thanks, folks.  Special thanks to Jason Long for posting demonstrative code to drive the point home.

So the correct...

But that doesn't have anything to do with how many drives you have or whether or not you mix MDFs with LDFs.  It only has to do with the speed...

Interesting... When and how is it incorrect... in any case?

You asked for help with performance... those are performance issues that need to be fixed... "in all cases" when...

Here's what you asked for, along with a last run status...

   WITH
cteJob AS
(--==== Get only the jobs that are enabled
 SELECT job_id ,name
  ...

I still cannot fathom the idea of or the need for updating the PK.

Why would people working with commodities only be interested in only the "end of each month + 2 days"?  And if you're doing it to condense the data for yearly...

With the understanding that I'm NOT an AWS EC2 ninja by any means, I cannot imagine doing anything different for drives (by letter) on EC2 than you would for your...