deleted

@P8 -- like all your improbably large/generic parameters -- is an nvarchar(4000). cid can't possibly be nvarchar(4000) and have an index/primary key -- it's too large to  be indexed. The...

Are you trying to reduce backup size and duration? Trying to improve performance? Are you trying to reduce cost by archiving to cheaper storage? Will the archived data realistically be...

One way would be to have an assignment # column in the association table -- e.g. AssignmentNumber. Use tinyint. And create a check constraint that limits AllocationNumber to 1 through...

It generally matters little, if at all -- the optimizer should be able to use statistics to order the predicates optimally.

Far more important are statistics and indexing. Without an appropriate...

No: "Scalar functions must be invoked by using at least the two-part name of the function (<schema>.<function>)"

Why are you even trying to work around this? You should preface all...

I actually tried it that way prior to the where clause way.  It does work, but the update will update all the matched records since there is no filter on...

We don't have your fn_GetAlphabetsOnly function -- that's a user-defined function.

The following returns EMA_T__MRNMM_PMSPAT_PID_OR_Dr:

DECLARE @string VARCHAR(255) = 'EMA_20210526T211254_0000_MRNMM0000001240_PMS110460PAT000001287_PID15235307_OR_Dr'
SELECT @string,REPLACE(@string,'%[^0-9]%',''), REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@string,'0',''),'1',''),'2',''),'3',''),'4',''),'5',''),'6',''),'7',''),'8',''),'9','');

Note: Your sample results don't seem to reflect...

Prior post referencing S.O. was flagged as spam?!?, so here's an abridged MSSQL version w/o links:

SELECT [Number], [Cost],
(SELECT Max(v) FROM (VALUES (date1), (date2), (date3)) AS value(v)) as...

Is it possible before it complete the backup of the one database it will start another database backup?

SQL Server Agent will not start another instance of a job if job...

Almost certainly not a factor in case statement/null logic, but...

varchar Column lengths are suspicious -- all varchar(50) in OptionsetMetadata  & varchar(255) in account. Are those really the column lengths used?...

deleted

Yes, post DDL & sample data.

How to post code problems

What data types are account.ts_ukrow & OptionsetMetadata.ts_ukrow? What data types are account.ts_primarysecondaryfocus & OptionsetMetadata.ts_primarysecondaryfocus ?

The CASE statements wrapping ISNULL() using empty...

Did you upgrade to a new version? If so, update statistics.  What version did you move from? to? (presumably one of them is 2017 since you're here)... If you moved...

Given how many times this identical question has turned up both here and on reddit, this has the earmarks of spam.

"AppVManagement"  & "AppVReporting" appear to be for Microsoft Application Virtualization: https://docs.microsoft.com/en-us/windows/application-management/app-v/appv-for-windows, https://docs.microsoft.com/en-us/windows/application-management/app-v/appv-deploy-appv-databases-with-sql-scripts

ReportServer...