Viewing 15 posts - 3,436 through 3,450 (of 8,415 total)
Chris Morris-439714 (5/14/2010)
Anytime, Paul - I'm kinda relieved to see you providing evidence that you're not spending all of your time hunched over a keyboard!
It does happen!
May 14, 2010 at 8:15 am
Peter Brinkhaus (5/13/2010)
Below a more optimized version to show all the number of nodes in the left and right branch of any node. However, still a triangular join.
Very cool, Peter...
May 14, 2010 at 8:00 am
Chris Morris-439714 (5/14/2010)
May 14, 2010 at 7:37 am
CirquedeSQLeil (5/13/2010)
Thanks Gianluca. I particularly like how Paul handled this...
You would have loved my first draft reply 😉
Celko is undoubtedly a reasonably bright individual, but his people skills are...
May 14, 2010 at 6:55 am
Hey Jeff,
As you know, there's nothing much in either of your replies that I don't agree with. 🙂
I set a pretty high bar for SQLCLR code that wants to be...
May 14, 2010 at 6:51 am
mister.magoo (5/14/2010)
That sounds about right - the SQLCLR version is blindingly fast in my tests too....Someone must be able to make a T-SQL version that comes close....Jeff....?
I'd be amazed if...
May 14, 2010 at 3:32 am
Jeff Moden (5/13/2010)
What were the results on, say, a million rows?
I downloaded The Complete Works of Shakespeare, split it into sentences and ran both routines on that. Turns out,...
May 14, 2010 at 1:49 am
Tony,
The article presents a general model for paging, in particular one which makes it fast to return any page from a set of any size. If you have a...
May 13, 2010 at 11:45 pm
mahbub422 (5/12/2010)
Dear Paul. Your technique is better. So, I am interested to use your technique. Peter also suggested me to follow your method.
It is an alternative - whether it is...
May 12, 2010 at 10:39 pm
Joe Celko (5/12/2010)
Paul recognized that the problem is the DDL, but he still had his head stuck in proprietary, non-relational code. He did not go far enough.
No, my intention was...
May 12, 2010 at 10:11 pm
Amol Naik-681410 (5/12/2010)
May 12, 2010 at 9:53 pm
Amol Naik-681410 (5/11/2010)
May 12, 2010 at 1:25 am
johnzabroski,
"Your solution doesn't work on edge cases where data elements themselves may contain pipes."
No, of course it doesn't, but that's not the point. :doze:
The point is to give you away...
May 10, 2010 at 8:50 am
On a quick inspection, wouldn't the following avoid the extra sort?
with cteRows
as (
Select col1,
...
May 9, 2010 at 9:10 am
Viewing 15 posts - 3,436 through 3,450 (of 8,415 total)