Hi,

We've been discussing this in a different area of the forum and the issue has been resolved so I wanted to come post the solution here in case anyone stumbles...

Here is the new query, if you are interested in the changes I made:

Declare @BuyerName as nvarchar(50);

Declare @StartDate as date;

Declare @EndDate as date;

Set @BuyerName = '' +...

Hi guys,

Thanks for your insights. I wondered about AGM_IsDateNull as well, so I looked at it and as far as I can tell it just checks if the value...

I absolutely agree that there are probably opportunities to better tune the queries. Part of the problem is that I am a decent .NET programmer but a total newb when...

Grant, I think you called it. It looks like the new cardinality estimator appears to be causing our queries to run much slower. We changed the compatibility mode to 2012...

Thanks for replying. I'll take a look at AskBrent. Hopefully that will help.