Viewing 15 posts - 54,121 through 54,135 (of 59,068 total)
HOLY SON OF A .. %&@$#@ !!!!
I never imagined the recursive CTE would be perform so poorly...
Heh... my work is almost done here...
Peter, did you have some...
November 13, 2007 at 7:32 am
... and what happened to the Cross-Apply Peter was talking about?
November 13, 2007 at 7:29 am
Yes, I used the tally table (or as you named it (myNumbers).
I didn't realize you wanted the Clustered index removed for the test.
So the new results with the PK...
November 13, 2007 at 7:26 am
This is starting to be a little like pulling teeth, Phamm...
Why does the report need to be in this format? No fair saying the users want it that way......
November 13, 2007 at 7:02 am
Jason,
Did you test only the Tally table method? Sorry, I can't really tell from your post...
November 13, 2007 at 6:29 am
You're getting a "scan" on the Tally table? Did you remove the Clustered Index it had?
November 13, 2007 at 6:27 am
Took the words right out of my mouth... prize for participants and casual observers alike will be more knowledge. "Some of the best 'Things' in life are not 'Things'"...
November 13, 2007 at 5:49 am
Cool... now we're talking some testing!
November 13, 2007 at 5:46 am
Seriously, Phamm...
I just wanna know before-hand for 2 reasons... will determine the method I use and I'm collecting "reasons" for this... just explain why you need to do this. ...
November 13, 2007 at 5:43 am
I won't pass a table variable... best you can do is a result set that get's used as a table.
November 13, 2007 at 5:37 am
Shaun McGuile (11/13/2007)
Just be consistent and be prepared to do translation when porting your SQL to other...
November 13, 2007 at 5:34 am
Shaun McGuile (11/13/2007)
Jeff you rascal 😀
Heh... You know me, Shaun... I even challenge myself if I think I'm wrong 😀 Good man once told me "A Developer must not...
November 13, 2007 at 5:29 am
Sure... a little off topic... but I love it! Looking forwards to your post(s), Gail.
November 13, 2007 at 5:25 am
Viewing 15 posts - 54,121 through 54,135 (of 59,068 total)