Viewing 15 posts - 241 through 255 (of 1,082 total)
did you try and update the stats like Grant mentioned. I'm very interested to know why different versions of sql are giving very different results
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 9:51 am
wow this is very strange....
I've created two tables with with the columns in your query added data and indeed the query runs in secs if not milliseconds on 2000 and...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 7:00 am
hwo long did you say the 2005 query takes vs the sme query on 2000?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 6:43 am
mmm
Please confirm if this is a double post or not?
http://www.sqlservercentral.com/Forums/Topic694547-146-2.aspx?Update=1
If it is then could the reason not be that your code is different.
The one removes 0's and the other doesn't
as...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 6:34 am
This is double post :
http://www.sqlservercentral.com/Forums/Topic696401-149-1.aspx?Highlight=BIBNAC
And to be honest those two queries are completely different.
In that in the first one the optimizer could if it wanted use indexes.
In the second query...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 6:33 am
I'm with Chris...
Oh another thing is to maybe SET NOCOUNT ON at the beginning of the proc.
This sounds wierd but I have seen some ASP and PHP code fall over...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 6:18 am
could you save the execution plans as .zip files and attach them.
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 5:52 am
could yo post some example code please?
also if you time perhaps the two different execution plans 🙂
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 5:51 am
why does .NET fall over when you have a return in your code?
Thanks for the solution, just hoping for an explanation as well
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 5:49 am
the return was removed from within the if statement!
Did that fix your problem?
If it did I would be interested to know why?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 4:42 am
I think the OP wanted the return there so that no records are inserted...
otherwise good move taking it out but that shouldn't change the nature of the output param should...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 3:25 am
There are a few things to check on the asp side as from what I can see you proc looks fine, other that if something doesn't exist then a null...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 3:13 am
I normally always use this format 'YYYY-MM-DD'
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 15, 2009 at 3:07 am
As mentioned the UDF's are different, which means you comparing apples and oranges...
Could you post the two UDF's and then we can let you know how to improve them, or...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 14, 2009 at 10:05 am
I don't think MDX is t-sql either
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
April 14, 2009 at 6:03 am
Viewing 15 posts - 241 through 255 (of 1,082 total)