I haven't seen any solutions where CalendarCycleStart or CalendarCycleEnd is included in the CROSS APPLY select statement, so they wouldn't be usable in the where clause right?

Something else I've noticed.  The query that runs fast has does a seek on the p1 alias with 2 seek predicates ( parentID = null, pkg_id = {pkg_id in where...

I've come up with the following way to get the list of pkg master IDs with a recursive CTE.  My question now is, why does it take nearly 4 sec...

I thought about that, but both VMs use the same datastore, so if it was disk contention they should both be effected.  It seems to be related to the VM. ...

Also, the -t may not work without a separator arguement such as a comma. i.e. '-t,'

Upon reading the article a bit, I'd point out that you need to use an uppercase '-S' to identify the server name.

A good MS article.

https://blogs.msdn.microsoft.com/timart/2012/08/30/bulk-copy-use-bcp-from-sql-to-concat-databases/

I'm not sure about this particular command, but command options are usually case sensitive.
The output error seems to indicate the -t option should be lowercase.
You may want to...