Okay I do not recall all the details but a word of warning. With a Partitioned Table you have to include that partition within everything you do or you...

standards - and for those that do work a lot on this and use tools to help with coding, putting the alias can be automatic, and expanding the columns will...

Yes. I've reported...

with recursive is not a MS SQL option. It is available on other DBMS like Postgres.

first - what is the datatype of validon in both tables?

and secondly - I'm sure the answer to the first question will tell us it is a int or a...

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