Run this against your Instances

IF OBJECT_ID('tempdb.dbo.##enterprise_features') IS NOT NULL
  DROP TABLE ##enterprise_features
 
CREATE TABLE ##enterprise_features
  (
     dbname   ...

for other readers benefit it may be worthwhile posting the T-SQL version of the above code.

I'm sure many will have some difficulties with similar constructs

that is Oracle SQL - Pipeline or Parallel Table Function - see https://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dcitblfns.htm

and if you crosspost to other forums at least have the courtesy of posting the link to the...

I would change it to have the following construct instead

insert into ....

select @Location
     , sum(case
        ...

you don't need to be a admin to get AD information out of. although your AD admins may have locked it down so normal users are unable to "read" AD...

depending on your version maybe this will work https://quickbooks.intuit.com/enterprise/customer-resource-center/odbc-drivers/

one that isn't that expensive is Devart https://www.devart.com/odbc/quickbooks/ordering.html

what is 25Cr records - please give the full number. e.g. 25 000 000 or 2 500 000 000.

if it is what I think then you better get another 400...

if the database itself isn't on the terabyte size level why not just create an empty db and migrate all objects to it EXCEPT that one? then simple backup and...

as a rule always allow for free space 2.5 times the space of your biggest index. - both on data and on log file

you need to redo it on 2008 BIDS.

2012 and higher its easier to "change" but 2008 to 2012 was a major change of SSIS Engine

it helps to read the manuals https://docs.microsoft.com/en-us/sql/t-sql/language-elements/if-else-transact-sql?view=sql-server-ver15

according to the code you posted it does not seem you need that cte - and without your full code we don't know if you missed something on your post...

Giving sample sql like this may lead to errors - and for this you may need to supply us with a full explain plan (both slow and fast).

we will also...

script attached.

can easily be changed to filter only the procs you desire on the line

$storedProcs = $db.StoredProcedures

as you are not a DBA what you can do is talk to your DBA's, discuss your concerns with the performance of those databases and see what type of monitoring...