Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,111 through 34,125 (of 59,099 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Sorry folks. I had to take a break and actually work for a living. 😛 I'll be back tonight.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 11:02 am

#1318563
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

@mark-3,
IIRC, I believe I tried doing pre-aggregation in an mTVF and it slowed things down too much (I stated something to that effect in the article). I can't find...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 9:02 am

#1318458
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mtassin (5/2/2011)
Today I get to learn something, I figured the issue with the concatenation was that as it was part of a WHERE clause that was re-applied as the tally...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 8:38 am

#1318434
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Solomon Rutzky (5/2/2011)
Jeff Moden (5/2/2011)
David Data (5/2/2011)
All these methods use CHARINDEX to efficiently see where the next delimiter is. But what about handling CSV strings with quoted text, e.g....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 8:20 am

#1318412
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Robert Livermore (5/2/2011)
Congratulations, You just rediscovered a LRLA(1) parser (left to right lookahead one), invented in 20 years ago by DICK GRUNE and CERIEL JACOBS. PARSING TECHNIQUES A...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 8:05 am

#1318405
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mtassin (5/2/2011)
Lol I finally made a mention in one of Jeff's articles.
One day I'll have to collaborate with Jeff to define just what this alliance is.
On another note though, I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 7:58 am

#1318401
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

rmechaber (5/2/2011)
Jeff, your exposition of how you mentally wrestle with a problem was exceptional. That alone made your article worth reading! You've got a rare combination of technical...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 7:40 am

#1318393
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Gianluca Sartori (5/2/2011)
Jeff, your article is great!
The final splitter function could have been 3 times slower than the original one, and the article would have been memorable anyway. It's a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 7:27 am

#1318388
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

David Data (5/2/2011)
All these methods use CHARINDEX to efficiently see where the next delimiter is. But what about handling CSV strings with quoted text, e.g. where "John Smith","23, The...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 6:21 am

#1318352
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Abrar Ahmad_ (5/2/2011)
Solomon Rutzky (5/1/2011)
Very thorough analysis. Great job!
Take care,
Solomon...
[font="Verdana"]
But it seems at least a week long activity !!!
😛
Goodish!
[/font]
Heh... it seemed like a year to me. Thanks...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 6:12 am

#1318348
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Solomon Rutzky (5/1/2011)
Very thorough analysis. Great job!
Take care,
Solomon...
Thanks for stopping by, Solomon. 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 2, 2011 at 6:11 am

#1318347
RE: EAV's and NVP's are bad. So... What do YOU use as an alternative?

Thanks for the feedback, Craig. I'm going to hold up on telling folks whether or not I use them because I don't want to bias anyone. I might...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 1, 2011 at 11:38 pm

#1318288
RE: SQL aggregation

And, no... there's not a lick of dynamic SQL in the code. It's just the changes they made to the forum code does that in the presence of '\'...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 1, 2011 at 8:50 pm

#1318270
RE: SQL aggregation

Because D & E have no "PrevID", the look like two top level nodes to me. If I'm wrong, we'll have to try this again. If I'm right,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 1, 2011 at 8:48 pm

#1318269
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

bitbucket-25253 (5/1/2011)
WayneS (5/1/2011)
Jeff, I had to rate this article 5 stars, because that's as high as the ratings allow. It deserves a 15!
BTW, I'm aghast --- you've actually used a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 1, 2011 at 4:50 pm

#1318265

Viewing 15 posts - 34,111 through 34,125 (of 59,099 total)