Can you post the code for all the sql involved (including functions etc)

Paul White (2/27/2010)

Very nice. I seem to recall that...

I have a blog entry on dynamic sql and unbalanced data loads which seems appropriate to pimp here 😉

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/optimal-query-plans-with-unbalanced-data-loads.aspx

Things seem to get more complex:

Because I want to consolidate matches from different tables, in Dave's suggestion, splitting WhitePage to two tables means I need to add extra OR in...

Have you got auto update stats set on the database ?

If not use UPDATE STATISTICS command

I click on the Estimated...

Its the lookup to WhitePaper that is killing you ?

Are your stats upto date ?

I agree that this is not an actual plan but an estimated one.

Does this perform better...

Replacing a cursor with a while loop is not a hell of a lot better, the object is not to loop either by cursor or a while loop.

First off if...

Are you getting an error or does it appear to be working?

just fyi i think this is performing badly due to a bug in 2005 ive documented here

What you need to do is use top(1) within the cross apply with than...

Im with Lutz on this one.

Not knowing your performance problem , its hard to be specific but a partitioned table would be a better solution.

Can you provide DDL and sample data ?

I have one or two ideas i would like to try.

I would expect the non filter to be slower , but only because of the amount of data that needs to be sent to the client. Not for any...

Both will have to scan the complete table.

The only ,noticeable, difference would be that amount of data that the non filtered version will return to the client.

They should show in those , are you sure you are not filtering them out on another condition

Subtracting 7 hrs should work

Heres one option, untested

Select fileid,dateadd(hh,-7,OutTime) as Date,

sum(UploadJobs) as LiveJobs

...