Viewing 15 posts - 8,311 through 8,325 (of 8,416 total)
Hey Flo,
If I were wearing a hat (tinfoil or otherwise), it would now be off to you.
Awesome stuff as usual.
For anyone not familiar with Flo's work, I would encourage you...
April 14, 2009 at 11:24 pm
Peso (4/14/2009)
Or a faster split UDF?
PRINT 'Start Peso solution'
...blah blah blah...
Awesome. You have saved the day! Well done sir! :ermm:
I can't wait for the version of your...
April 14, 2009 at 5:06 am
RBarryYoung (4/13/2009)
April 13, 2009 at 3:22 pm
Jeff Moden (4/12/2009)
April 13, 2009 at 3:14 pm
Hey Dan,
In my experience, it is SSAS (and cubes in general) which do not scale well.
The last QV solution I worked on had 2,500 users (admittedly only 50 or so...
April 13, 2009 at 3:06 pm
Flo,
More great stuff from you again...!
I hope your internet connection is fixed soon.
Off to bed now, but thanks for the XML CLR solution - neat (though I am naturally XML-sceptic).
I...
April 13, 2009 at 5:09 am
Hey again Flo,
You might like to also try this with a CLR TVF.
I tried it on your sample and got:
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0,...
April 13, 2009 at 2:52 am
Jeff Moden (4/12/2009)
ORDER BY on unindexed Tally table, for starters. All the other comments about large table variables may apply, as well, although I haven't tested the code, yet.
Unindexed?...
April 12, 2009 at 11:33 pm
Hey Flo!
It is true to say that the following features of the script won't help overall performance:
1. Using table variables (no statistics are available and parallelism cannot be used)
2....
April 12, 2009 at 10:42 pm
Jeff Moden (4/12/2009)
April 12, 2009 at 10:18 pm
Jeffrey Williams (4/12/2009)
Paul White (4/12/2009)
It's also possible to read all possible data into XML and run an XQuery... :-D/PPaul - I'd quit now while I still had the chance 😀
Splork!
April 12, 2009 at 10:34 am
GilaMonster (4/7/2009)
Jeff Moden (4/7/2009)
April 12, 2009 at 10:25 am
GilaMonster (4/12/2009)
Paul White (4/12/2009)
It's also possible to read all possible data into XML and run an XQuery... 😀
If you're going to make suggestions as to how something can be done,...
April 12, 2009 at 10:13 am
As Krishna mentioned, it is probably a blocking issue. I suppose it could (technically) also be a deadlock - deadlock detection is not instantaneous after all. I didn't...
April 12, 2009 at 9:42 am
GilaMonster (4/12/2009)
Multi-statement table valued function...
April 12, 2009 at 9:25 am
Viewing 15 posts - 8,311 through 8,325 (of 8,416 total)