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...

yeahh.... and then it fails because of names that have the strings like this one "Southmoreland School District" or "northampton"

its a nearly impossible task without a table with exceptions and...

look for dbatools.io - with it you can script some, but not all of the objects, and can apply filtering.

and I may be able to post another script that does...

Can you tell more about these effects...

normally with Dynamics applications you can't enable CDC at all - and you just saw one of the effects of doing so.

enabling CT or similar is your best option -...

the time the SSIS package is taking to load the data is most likely related to how the processing is implemented than to how the partitions are setup - and...

or better yet - setup a powershell that executes all required queries and writes the output of each onto a csv file (one per query) - and set it so...

have a look in the manual for substring and convert, and potentially "stuff" - with the you will be able to do what you need.

and if after you read the...

you need to add " (double quote) as the text delimiter on the definition above - once you do that you will be able to open the file correctly in...

That's nice points you said. I was trying to automate this process using SQL Server agent job and selecting SSIS, once I have my export package saved. I tried...

what indexes exist on the parent table?

most likely there is one already covering all the columns on that where clause - and if so the effective date should most likely...