there is no official cut off. the lowest possible is best.  the run time for the entire 1000 line...

small error on my original code - the temp table was referring an non existing alias (t1)- easy to fix I think.

another attempt at simplifying it assuming that I...

no difference.

your code was only looking for the the friday date on a particular situation e.g. when the EXPIRATION = Thursday

so by determining all the FRIDAY dates in advance,...

no difference.

your code was only looking for the the friday date on a particular situation e.g. when the EXPIRATION = Thursday

so by determining all the FRIDAY dates in advance,...

adding further indexes on this case likely not the best - the underlying table is a columnstore table.

the thing that would speed up the most is to have a...

adding further indexes on this case likely not the best - the underlying table is a columnstore table.

the thing that would speed up the most is to have a...

• This reply was modified 2 years, 10 months ago by water490.

This is an equivalent query

SELECT T4.UNDERLYING_SYMBOL,
       T4.QUOTE_DATE,
       T4.EXPIRATION,
      ...

Are you attempting to restore over the top of another database? (Did you change the name of the database you're restoring? You should have). Once you do that, you...

thanks for that link.  here you go

https://www.brentozar.com/pastetheplan/?id=SJTjb9cIh

Why settle a tie using query logic, what about a unique index?  Some or one of those could be helpful.  A table containing holidays to exclude could be useful...

I have attached the execution plan if that helps.

• This reply was modified 2 years, 10 months ago by water490.

i wasn't able to delete the original attachment.  use test-data-1.csv and ignore other one.

No they are not.  I never did that before and the logging was working then.  No clue what happened that cause it stop logging. ...

thank you for that!

The source table had a different level of precision.  Once I matched the destination so it matched the source it worked.

thank you everyone for the reply.  There is no error message on why it failed so that is why it is so puzzling.  I am continuing to investigate to see...