Thanks for that mate. I think your query returns less rows because of this condition.

AND (

SELECT...

Thanks for doing all of that 🙂

Let me explain. The server has 4 processors. MAX DOP is set at zero, meaning optimizer will use as many number of processors to...

Most expensive operation in my query is for sorting, which we cannot avoid I think. Can you please do the following and check if there is any improvement?

1. Firstly, do...

SET STATISTICS TIME ON

Ok. Can you try doing this ^ before running the query and check the Messages tab for details?

Or run the following query, add text from the query,...

No notifications on edit mate. What's the difference between execution time and total time?

Douglas, can you also post the execution times please? I think I know why my query is returning more rows.

Does this do it for you? You don't have to join with Customer table unless you are missing a FK, which is not a good practice anyway.

;WITH cte AS

(

select...

How does this one fare? It should generate a different plan from the one I have posted. Those scans are going to be expensive, considering you have a year's data....

Were you able to find a resolution for this issue?

We have multiple production servers, all on SQL Server 2014 latest SP and running ACE OLEDB 12.0

Only on one of the...

@eric: Thanks. That's a good story that, had never heard of it. With some new resources in, I have more time at hand and I've been putting it...

Thanks for asking Abrar. Let me start by apologizing for not answering any sooner.

The last couple of months were tumultuous. My teammates quit and I'm the only dev left in...

Thanks Grant. These are invaluable pointers. I like writing and I look forward to contributing to the community. I'm hoping I will stay focused and pick a few good habits....

Thanks Hugo. I've seen the posts before, but never gave it much thought. It looks very interesting.

7sinz: Thanks for your perspective. I agree that it is silly to go all...

Thanks Phil, that's a good point. I will pitch that.

Eric, I think I might just give MCSE a go. What put me off in the past was a few candidates...

Thanks for your valuable inputs. I think I can join the local user group, that's a really good suggestion. I have a vision for where i want to be 5...