Hi Scott, this is oversimplified but it reproduces the problem. The question becomes, what is missing so we do not have to wrap EA.IsArchived in a ISNULL?

/*
DROP...

I do have this index. It is clustered and unique (but I also tested non-clustered and non-unique versions of it). Every "fast" plan is using it.

I will take some time...

Thanks Scott and Jonathan. I agree that the statement is confusing for both developers and SQL Server. My problem is that this statement (which is actually an extract from a...

• This reply was modified 3 years, 2 months ago by  cmartel 20772.
• This reply was modified 3 years, 2 months ago by  cmartel 20772. Reason: typo

Hi Daniel,

I actually store shares and votes per share. Most corporations have outstanding shares that are often big integers and votes per share that are small integers (typically 1 but...

Hi WHS,

I am not sure of what you mean by "vs implementing a function". The only way I know to prevent SQL Server from truncating is to perform the truncation...

• This reply was modified 3 years, 4 months ago by  cmartel 20772.
• This reply was modified 3 years, 4 months ago by  cmartel 20772.

Hello Mike,

As knowledgeable Joe might be, he seems to ignore some of the challenges programmers are facing each and every day.

I can certainly write better code than the script I...

Thanks a lot. I will preciously keep a copy of this code!

Jeff,

You do not understand and that is OK. I clearly stated in my initial post that CLR neither optimal nor required in my example. I am simply experimenting with CLR...

• This reply was modified 5 years ago by  cmartel 20772.

Thanks Solomon,

I am using the exact same query. Having two distinct queries for states and countries is not an effective long-term solution since I may need to join multiple times...

As far as I can tell, the 2017 plan is identical to the 2014 plan (and isn't expected?)

Here is the TimelineMatch function. I have to admit it is a strange function and its purpose is to avoid writing «

November 1, 2018 at 8:13 am

#2012048

Thanks andy,

I moved the expression into an OUTER APPLY and the statement runs faster than ever (and that was expected).