you either split them into rows in a table or you use dynamic sql . both of these assume you care with good performance.

not looking at performance there is a...

it could be the "LEGACY_CARDINALITY_ESTIMATION " being set to ON.

see https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact-sql?view=sql-server-ver16

IF the split means that you can "reduce" the number of rows in one of the tables due to "duplicate information" then you should do it if savings are significant...

while that may have been the case in older versions, actual versions DO ALLOW it for sure.

I would really ignore that - it is one of those vulnerabilities that require a USER to open a supplied third party file (specially crafted to abuse the vulnerability) on...

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