Which is why I like Rugby, as "hardcore" and rough a sport as it is, there is hardly ever any swearing at the ref, and if there was it...

Yeah it's a not a perfect solution but I have had to use it sometimes, as I often find that the overhead of parallelism is too much for my poor...

Thanks Lynn 🙂

(Chris finds some of his marbles)

I think Roy has an interesting point.

The optimizer might be going for the clustered index because it thinks that using the bookmark might be expensive which it usually is.

I'd be...

OK time for some sleep, I've lost my marbles... Sorry Carl, I'll try have another look at this next week if you still need.

(Bookmark lookups don't happen with Clustered Indexes[hence...

Hi Carl,

I hope I haven't wasted your time here, I've got some test data on my machine and I'm gonna try and play around but I think what you have...

Sorry yip friday is getting to me, there are no joins to other tables hence no look-ups

thanks.

Wow that is strange unless I'm missing something (very possible) being late Friday afternoon.

I'm not 100% what other advice to give.

Oh and that is the ACTUAL EXECUTION PLAN right and...

I think might be outside of what you are wanting to discuss, but it might be worth adding a non-clustered index to your School table that contains the SchoolName as...

sorry maybe I'm blind, but I can't see any difference in the two queries.

as stated could you supply the execution plan.

I would be supprised if SQL didn't re-organise the tables...

just seems strange cause for this query

select cumul

from empscumul

where stat_no = 11

and employee_id = '8119'

and start_date = '20070301'

The column cumul is not in your...

Thanks.

sorry I'm not great with that type of output sorry.

Acount you save the graphical plan and attach it

no problem.

The only other thing I think of but I have feeling it will perform badly, is to use a CLR and call that.

But I'd be interested to know what...

Can't you use a stored procedure as the source for the report?

Have you tried looking it up on BOL?