Something like that.

If you want 7 days ago midnight you can use something like this instead

SET @Start = DATEADD(D, -7, DATEDIFF(D, 0, GETDATE()))

Been there, done that. The only way you really learn something is by whakking around it for hours :hehe:.

GSquared (12/20/2011)

---

Dev (12/20/2011)

---

Sorry for hiccup. I Google-d something today (after a long long time, using Bing now days) and didn’t find a single sponsored links there. No promotions...

Then tweak the dlookup. Not sure enough of the syntax to help you out here.

The estimates are WAY off.

I'd try with not exists and make this the clustered index fz_senddat.

That should improve this immensely.

You still have those values in the combobox right? Just get them there with the column index and you'll be fine.

Actual plan has WAY more info about what's going on in that query. 1 of the most important is actual rows vs estimates.

This is an estimated plan, almost useless to debug performance.

You see a ton of operators because you are selecting from a view, not a table.

There's a timeout error in the...

That's the estimated plan, we need the actual plan.

+1 on the clustered index benefits, especially on such a large table.

We'd need the actual execution plan to help any further.

Wrong object, correct event.

Dev (12/19/2011)

---

Steve Jones - SSC Editor (12/19/2011)

---

GilaMonster (12/19/2011)

---

I don't think I should say anything about when I started, or there may be overripe pawpaw coming in my general...

I'd debug this with sp_WhoIsActive

http://sqlblog.com/files/default.aspx

And those articles as well

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2

The other issues with views of views of views of views, is that you often access the same objects multiple times.

Now the optimizer is EXTREMELY smart. If it can...

You need to rescript the whole thing and control it yourself. Here's how you can script a trace from the trace definition's tables.

http://www.sqlservercentral.com/Forums/FindPost1191969.aspx