first thing is to fix the logic - NEVER EVER use FORMAT and then compare its output with something else, especially if it is not a equality compare.

on your first...

5.3 million rows is the estimated - the actual is 37k rows

Statistics on columnstore can be a bit tricky as they don't quite work as other tables - but I...

maybe this but not guaranteed.

drop table if exists #TEMP1;
drop table if exists #TEMP2;
drop table if exists #TEMP3;

select distinct T1.QUOTE_DATE
into #TEMP1
from dbo.OptionsEOD T1

CREATE CLUSTERED INDEX #CI_TEMP1 ON #TEMP1
(QUOTE_DATE
);

select...

try the following code.

and then give us the actual explain plan for both this code and your code.

drop table if exists #TEMP1;
drop table if exists #TEMP2;

select distinct...

Using a sequence, can a process get a set of 5000 values and then use those values as the PK? WHILE another process performing the same task in parallel...

you can use a sequence for that instead of an identity.

loopback? have a look at https://blog.sqlauthority.com/2017/04/18/sql-server-login-failed-login-untrusted-domain-cannot-used-windows-authentication/

and https://arslan-bobir.medium.com/sql-server-troubleshooting-resolving-the-login-is-from-an-untrusted-domain-and-cannot-be-used-7a1a6c715817

and... probably not but worth looking at.

https://learn.microsoft.com/en-us/windows/security/threat-protection/security-policy-settings/network-security-configure-encryption-types-allowed-for-kerberos - if a new server it is likely that RC4_HMAC_MD5 is disabled - if so try enabling...

is this still using the same formula you had on your original thread (https://www.sqlservercentral.com/forums/topic/round-or-convert-the-output-of-the-power-function) - or are you now trying to use the correct IRR

when using the NT Service account the SPN's are created under the COMPUTER account.

setspn -L "computername$" will give the specific SPN's that were set.

but... if you already changed the account...

the question is WHY - I fail to see any reason why using temp tables would be an issue. that is what TEMPDB is for, and there are no special...

did you follow the steps here https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-two-instances-and-sql-server-configure-tutorial?view=azuresql

SQL MI to onprem does not follow standard way of doing it between 2 onprem servers.

as far as I remember the latest version of SQL BPA is for 2012 - https://www.microsoft.com/en-in/download/details.aspx?id=29302

nothing seems to have been done (or will be done ) on that tool so...

not much you can do about that query (which is the version I gave you) - the nature of the query does not really allow for pre-filtering or use of...

did you do the steps highlighted at https://cloudblogs.microsoft.com/sqlserver/2022/07/28/azure-active-directory-authentication-for-sql-server-2022/

times on a I7 6 core laptop

according to explan plan query cost (relative to batch= are 0, 0, 100% respectively  - so DEFINITELY NOT something to use.

- with while loop...