Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,096 through 34,110 (of 59,099 total)

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

UMG Developer (5/2/2011)
mtassin (5/2/2011)
On another note though, I notice something about the final graph of performance around the 270 mark on the X axis. The pure SQL set based...
--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:48 pm

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

Nadrek (5/2/2011)
Jeff Moden (5/2/2011)
...
I also usually prefer TAB delimited or, even better, ASCII characters 28 through 31 (yep, there are characters designed for this type of stuff but no one...
--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:44 pm

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

tfifield (5/2/2011)
Jeff,
Brilliant piece of work! I did something a bit similar but cheated by always appending the last delimiter to the string in the function call. I always...
--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:34 pm

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

gary.rumble (5/2/2011)
I'd be interested in seeing the data you used for benchmarking.
It's in the third paragraph of the Prologue, Gary.
Shifting gears, there are 3 "obviously named" attachments to this article....
--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:30 pm

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

UMG Developer (5/2/2011)
Thanks for the excellent article that was both entertaining and instructional. I will be making use of your new splitter soon!
Thanks, UMG. Like I said to someone...
--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:23 pm

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

mark hutchinson (5/2/2011)
Jeff,
Thanks for writing both articles. I still don't understand why you use the CharIndex() when you could use a cursor to iterate through the delimiter positions. ...
--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:21 pm

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

JJ B (5/2/2011)
Thanks for the article.
While not the focus of the article, I wanted to thank you for the Nibbler and Inch Worm sections. I don't know if you...
--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:19 pm

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

virtualjosh (5/2/2011)
Good article. I come from an application environment where I had more flexibility to use outside coding. I'm happy to see we can do interesting things while still in...
--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:15 pm

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

Lynn Pettis (5/2/2011)
Just wanted to add my 2 cents as well. Very well done. I will be adding these routines to my toolbox as well.
I'm curious, I'm wondering...
--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:14 pm

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

Lynn Pettis (5/2/2011)
Just wanted to add my 2 cents as well. Very well done. I will be adding these routines to my toolbox as well.
I'm curious, I'm wondering...
--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:48 pm

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

Geoff A (5/2/2011)
Awesome article. Thanks for the effort, Jeff.
Thanks for stopping by at work, today, Geoff. It means a lot to me when someone like yourself takes the time...
--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:42 pm

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

sdorris-1150234 (5/2/2011)
Like I said before, when Jeff speaks - I listen.
Excellent article, Jeff! If this article was a "tsql how-to" in Barnes & Noble, I would buy it.
And like...
--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:39 pm

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

mtassin (5/2/2011)
What outcry?
It was the dust bunnies... 😛 They insisted on an iTVF which required no external considerations. They threatened to replace my beard if I didn't comply....
--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:33 pm

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

Robert Livermore (5/2/2011)
Irony.codeplex.com LRLA(1) parser allows the definition for any BNF based grammar. Provided the grammar specifies the literals for double quote and CRLF characters then parser should handle 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 8:28 pm

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

WayneS (5/2/2011)
mtassin (5/2/2011)
WayneS (5/2/2011)
BTW, since the new code was not compared to a physical, permanent tally table, I thought that I would mention that while testing this code out for...
--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:23 pm

#1318828

Viewing 15 posts - 34,096 through 34,110 (of 59,099 total)