Sql server edition (express, standard, enterprise) - developer --- if you are using this for Production usage you CAN NOT use developer license - if it is only for...

those files you are getting.... can you answer the following.

• how many files per load
• how many rows per file (max, min and average size)
• how often you get...

why are you dropping and recreating the indexes? what are you trying to accomplish with it?

(for Phil - OP has DROP_EXISTING = ON so indexes are there already while...

Are you saying that this proc runs slower in SSIS than it would if you were running it from SSMS?

Have you determined which statement is the slow one (I...

Internet has a...

It would appear that a simple definition of what you want is as follows:

Return the last weekday of the month (regardless of any holidays).

To help others understand...

As you have not provided the logic for your 'business month end' calculation, I'm not sure how you are expecting anyone to calculate it.

EOMONTH() gives you end of month...

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

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

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

no problem

here you...

Did...

no problem

here you go

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

thanks for all the replies.  much appreciated.

Some background...I have been making changes to a stored proc.  I made a change (not sure exactly what tho) that resulted in incorrect query...

regarding your last query (from the second plan). two options below

option 1 is just a adjustment of your original query - does same thing but with 1 less join....