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

it works now.  I am seeing seconds!! ...

Still think it’s part of the insert in the proc as the convert to char needs to be outside of the dynamic SQL, as for why it was giving...

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

I would say that you have a trigger on that table that is removing seconds from the column.

and I also assume you are clearing that table in order to...

np

here you go

np

here you go:

stored proc:

ALTER PROCEDURE [dbo].[UpdateOptionsEOD] (@FILENAME varchar(200), @RECORD_ADD_DATE datetime)
AS

DECLARE @FILEPATH VARCHAR(200)
SET @FILEPATH = @FILENAME

--DECLARE @RECORD_ADD_DT datetime
--SET @RECORD_ADD_DT = @RECORD_ADD_DATE

DROP TABLE IF EXISTS #TEMP_TABLE;

CREATE TABLE #TEMP_TABLE
(
[UNDERLYING_SYMBOL] [nvarchar](10)...