Viewing 15 posts - 136 through 150 (of 1,082 total)
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 10:16 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 10:10 am
Thanks Lynn 🙂
(Chris finds some of his marbles)
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 10:07 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 9:54 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 9:42 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 9:21 am
Sorry yip friday is getting to me, there are no joins to other tables hence no look-ups
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 8:58 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 8:50 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 8:15 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 8:02 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 7:59 am
Thanks.
sorry I'm not great with that type of output sorry.
Acount you save the graphical plan and attach it
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 7:36 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 6:46 am
Can't you use a stored procedure as the source for the report?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 6:32 am
Have you tried looking it up on BOL?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2009 at 5:40 am
Viewing 15 posts - 136 through 150 (of 1,082 total)