Yes, that link should show...

perfect!

Thank you so much

thx.  it works

thank you everyone.  i will take a look at the suggestions.

Thank you to everyone who helped on this issue.  I modified the query so key results are put into temp tables and voila the performance improved big time.  The original...

To add to what Jeffrey said - if a CTE is mentioned in the following code 2 or more times it's evaluated and executed as many times. No caching...

One problem does stand out in the snippet -- use of most functions in WHERE clauses or JOINS prevent sargability (ability to use indexes)

WHERE ABS(T2.CALL_PRICE -...

the issue is not the sql itself but the whole combination - your system is likely constrained in memory and was unable to produce a plan for the full...

As was communicated in a previous post,  we don't know the definitions of the CTEs your referencing. Without DDL for all underlying tables/views, and the entire query, there is...

I ran each CTE and I think I found the problem.  It is this one:

SELECT
T2.UNDERLYING_SYMBOL,
T2.QUOTE_DATE,
T2.STRIKE,
T2.CALL_PRICE,
T2.PUT_PRICE
FROMNEAR_TERM_OPTIONS_CTE AS T2
INNER JOIN
(
SELECT
T1.UNDERLYING_SYMBOL,
         ...

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

I MAY be mistaken on this, but I think that an i9 is a desktop processor not a server processor. Generally, you would want to have SQL Server running...

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

I have seen some websites that rank i9 quite high.  Glen's site doesn't mention any i9 processors.  Only Xeon.  is there any particular reason why i9 are not mentioned?

Hi everyone

Thanks for the replies.  If I include the execution plan then does the query come with it automatically or do I have to add the query separately?

Thank you

the concern I have is that if it takes 15 seconds to process a 600 row table then what it is going to look like when it has to process...

i fixed the problem

i changed the original column datatype from smallint to int and now the error is gone.

thank you everyone!