Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,081 through 34,095 (of 59,099 total)

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

WayneS (5/3/2011)
Here's the results that I have. The "DemilitedSplit8Kpt" is the new DelimitedSplit8K function, with a permanent tally table.
It's true... a picture IS worth a thousand words. Thanks 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 3, 2011 at 5:10 pm

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

JJ B (5/3/2011)
From Jeff Moden: I was considering writing an article about the all-too-"secret" characters 28-31 and a couple of other goodies in "control character land". Whatcha tink? Worthwhile or...
--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 3, 2011 at 5:07 pm

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

Nadrek (5/3/2011)
Craig Farrell (5/3/2011)
B'narg! Whaaaa? After a point I'd have expected the Perm table to stabilize more to the memory build.
Wow.
Try one of the two double-CTE versions 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 3, 2011 at 5:03 pm

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

Roy Ernest (5/3/2011)
As usual, great post Jeff. Five star article.. 🙂
Thanks, Roy. I appreciate you stopping by. How are you doing after that last car crunch?
--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 3, 2011 at 5:01 pm

#1319452
RE: Are the posted questions getting worse?

GilaMonster (5/2/2011)
Grant Fritchey (5/2/2011)
GilaMonster (5/2/2011)
Woot!!!!!!!!!!
http://www.allenkinsel.com/archive/2011/05/further-promoting-the-growth-of-speakers/
Well earned too. Congratulations! Nothing like knowing you have a reservation.
And an invitation for a spotlight that I thought I'd missed out on by not being...
--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 3, 2011 at 3:01 pm

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

mtassin (5/3/2011)
Craig Farrell (5/3/2011)
WayneS (5/3/2011)
Here's the results that I have. The "DemilitedSplit8Kpt" is the new DelimitedSplit8K function, with a permanent tally table.
10 to 20 Characters per Element:
B'narg! Whaaaa? ...
--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 3, 2011 at 2:47 pm

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

ChrisM@home (5/3/2011)
Just so long as he hasn't recently offered to clear a table 😀 because there's no Open Windows!
Heh... that's the first lesson I teach every team. 😀
--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 3, 2011 at 2:43 pm

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

Except for the way they handled the final element, that's almost identical to the rCTE code I have in the test harness I included with the article. Thanks 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 3, 2011 at 7:49 am

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

ALZDBA (5/3/2011)
It's a pity some obscure character caught the attention of CNN, Bloomberg, Al Jazera, ... the day your great article got published.
For sure it would have been 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 3, 2011 at 7:32 am

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

srikant maurya (5/3/2011)
Great Job,
I will use these code for future use.
Thanks, Srikant. I appreciate the feedback.
--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 3, 2011 at 7:28 am

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

adnan.korkmaz (5/3/2011)
Great job! Thank you all those who have written, contributed or inspired Jeff.
I have done some tests on real data before using this new one, executing both under same...
--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 3, 2011 at 7:27 am

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

Anipaul (5/3/2011)
As usual, you have written another excellent article Jeff. It was great one.:-)
Thanks, Anipaul. Good to "see" you again. 🙂
--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 3, 2011 at 7:24 am

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

mark hutchinson (5/2/2011)
Jeff
I think you already identified the basic code in your articles. Since you have a test bed for performance comparison, I thought you might have tested 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 3, 2011 at 7:22 am

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

mark hutchinson (5/2/2011)
Jeff,
Glad I brought a wide smile or laugh to your face/heart. But I was serious. I'm used to minimizing operations in the normal course of performance-tuning....
--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:58 pm

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

gary.rumble (5/2/2011)
Well, so far I got:
...
I think your code is too much for my server. 😉
Yowch. The code is even split into batches. What you may have to...
--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:53 pm

#1318857

Viewing 15 posts - 34,081 through 34,095 (of 59,099 total)