Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,146 through 44,160 (of 59,101 total)

RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

steve dassin (4/17/2009)
I agree. Learning something new is just a form of grandstanding. It's a crutch for people who really haven't mastered what their already using 🙂
Then learn something new,...
--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)

April 17, 2009 at 10:08 pm

#980119
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Mike C (4/17/2009)
RBarryYoung (4/17/2009)
The irony here, of course, is that the thing that some readers found most objectionable was that I said that sometimes developers don't care about the quality...
--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)

April 17, 2009 at 9:38 pm

#980117
RE: Performance issue with tally solution

Florian Reischl (4/17/2009)
Hi Jeff!
Some intermediate results of my current tests. Some new CLR functions joined the competition ;-).
Very cool, Flo. I do have a couple of concerns. Since...
--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)

April 17, 2009 at 7:51 pm

#980098
RE: Performance issue with tally solution

Paul White (4/17/2009)
It is nice to see that RBAR operations (in the CLR) are now faster than all set based operations.*
* - Do not feel the obvious troll 😛
Why not?...
--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)

April 17, 2009 at 1:39 pm

#979945
RE: Are the posted questions getting worse?

Bob Hovious (4/16/2009)
You got extra points if it was a nasal coke spew.
You should get extra points... those suckers are painful !!
Pork chops... I don't even want to think about...
--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)

April 17, 2009 at 1:24 pm

#979936
RE: Are the posted questions getting worse?

Lynn Pettis (4/16/2009)
Jeff, I still have the PM where you said something about spewing soup as well. Remember the comment? She who walked on water because she knew...
--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)

April 17, 2009 at 1:22 pm

#979934
RE: Are the posted questions getting worse?

Lynn Pettis (4/17/2009)
Steve Jones - Editor (4/17/2009)
It was 70F on Wed here!!!
Supposedly a foot today. only about 3-4" so far and slowing. Torn as I'd like to play baseball Sun,...
--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)

April 17, 2009 at 1:19 pm

#979928
RE: Are the posted questions getting worse?

Gaby Abed (4/17/2009)
Do not go gentle into that good Thread,
Old age should burn and rave at close of day;
Rage, rage against the dying of the light.
I'm not sure, but 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)

April 17, 2009 at 1:12 pm

#979922
RE: Are the posted questions getting worse?

Kit G (4/17/2009)
It's all Al Gore's fault. Damn global warming!
Wonder if Al Gore is part of the Thread's plot to take over the world?
He must be... remember that he...
--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)

April 17, 2009 at 1:11 pm

#979920
RE: Just Walk Away - Blacklisting - and Twits without Twitter

Paul White (4/16/2009)
I will happily adopt a less emotive term if someone suggests a good replacement for 'brute force' 😉
Heh... nope... now that I understand what you mean, not necessary....
--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)

April 16, 2009 at 8:00 pm

#979373
RE: Just Walk Away - Blacklisting - and Twits without Twitter

Paul White (4/16/2009)
3. A tally solution remains an elegant, if somewhat brute-force, solution.
Thanks for the confidence on the book, Paul. I am curious though... you keep saying that...
--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)

April 16, 2009 at 7:49 pm

#979367
RE: Just Walk Away - Blacklisting - and Twits without Twitter

GilaMonster (4/13/2009)
My main issue with the person in question was that while I was the one asking the questions, he directed every single answer to my colleague (who was sitting...
--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)

April 16, 2009 at 7:22 pm

#979361
RE: Just Walk Away - Blacklisting - and Twits without Twitter

Steve Jones - Editor (4/13/2009)
And Jeff, don't think about canceling a book because someone found a different solution. There needs to be multiple ways to do things, and even if...
--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)

April 16, 2009 at 7:11 pm

#979360
RE: Are the posted questions getting worse?

RBarryYoung (4/16/2009)
Bruce W Cassidy (4/16/2009)
[font="Verdana"]On another site I frequented, this was known as the "coke spew". You got extra points if it was a nasal coke spew.[/font]
Ow, now that...
--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)

April 16, 2009 at 5:38 pm

#979342
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Thomas (4/16/2009)
It is clear that you gentlemen are missing the point. That developers should strive to refine their craft is obvious. No one disputes that. That set-based solutions are preferred...
--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)

April 16, 2009 at 5:30 pm

#979341

Viewing 15 posts - 44,146 through 44,160 (of 59,101 total)