Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,196 through 33,210 (of 59,099 total)

RE: A Little Interviewing Advice

Ninja's_RGR'us (7/20/2011)
There's only 1 question left. Would you still hire me to work under you?.. that's all I really care about atm :hehe:.
Only if you wouldn't mind working...
--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)

July 20, 2011 at 9:32 pm

#1356127
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Ken,
Thanks for stopping by. I'm glad you enjoyed the article and I certainly appreciate the feedback. Please see the note I left for Shannon above. It's...
--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)

July 20, 2011 at 8:44 pm

#1356120
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Nicely done, Shannon. I'd like to make one lil' teeny suggestion that will make your code absolutely fly. Instead of a very costly sort based on the unindexed...
--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)

July 20, 2011 at 8:40 pm

#1356118
RE: Are the posted questions getting worse?

SQLRNNR (7/20/2011)
...also need to find that Bankers Rounding thread(s).
Nah... it's a total waste of 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)

July 20, 2011 at 10:54 am

#1355865
RE: Are the posted questions getting worse?

Ninja's_RGR'us (7/20/2011)
So I guess that makes you the Micheal Jackson of SQL Server... still alive and breathing (which is not so obivous in your picture, but that's...
--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)

July 20, 2011 at 8:11 am

#1355644
RE: Are the posted questions getting worse?

GilaMonster (7/20/2011)
Jeff Moden (7/20/2011)
I understand that Gail Shaw will be co-presenting with you...
Yup, Grant and I are doing comed^H^H^H^H^H execution plans as a precon on the Monday.
If I make...
--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)

July 20, 2011 at 8:09 am

#1355641
RE: Are the posted questions getting worse?

Kiara (7/20/2011)
Jeff, I owe you for your tally tables posts, if for nothing else. They saved me from pulling my hair out over a calendaring issue awhile back - and...
--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)

July 20, 2011 at 8:05 am

#1355635
RE: Are the posted questions getting worse?

ALZDBA (7/20/2011)
Grant Fritchey (7/20/2011)
Jeff Moden (7/19/2011)
Grant Fritchey (7/19/2011)
Gianluca Sartori (7/19/2011)
There's someone you all know that deserves your vote here[/url].
I'm sure you know who I'm talking about. 😉
I was just coming...
--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)

July 20, 2011 at 7:56 am

#1355616
RE: Are the posted questions getting worse?

Brandie Tarvin (7/20/2011)
My vote is in. I hope you get it, Jeff. You're the only one of the lot that I know actually has a couple of "official" SQL phrases...
--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)

July 20, 2011 at 7:51 am

#1355611
RE: Are the posted questions getting worse?

Ninja's_RGR'us (7/20/2011)
Jeff Moden (7/19/2011)
Ninja's_RGR'us (7/19/2011)
Gianluca Sartori (7/19/2011)
There's someone you all know that deserves your vote here[/url].
I'm sure you know who I'm talking about. 😉
Wow Jeff must make a nice santa...
--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)

July 20, 2011 at 7:41 am

#1355596
RE: Are the posted questions getting worse?

David Burrows (7/20/2011)
Used to correspond with Frank a lot but I think he changed jobs and email. He does post on another forum.
Thanks for being one of the good guys...
--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)

July 20, 2011 at 7:38 am

#1355594
RE: Are the posted questions getting worse?

Gianluca Sartori (7/20/2011)
Lynn Pettis (7/19/2011)
I have to admit that working at Honeywell and with Oracle has taken me away from what I truely love, SQL Server and the awesome community...
--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)

July 20, 2011 at 7:35 am

#1355590
RE: Are the posted questions getting worse?

Grant Fritchey (7/20/2011)
All joking aside, I'd love to see you win this one.
I never did read what the winner would be awarded before the folks at work nominated me. ...
--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)

July 20, 2011 at 7:31 am

#1355588
RE: Are the posted questions getting worse?

Lynn Pettis (7/19/2011)
Jeff Moden (7/19/2011)
But a late congrats to Lynn as well.
Dang it. I haven't been keeping up and I've obviously missed something good.
Lynn... what did you do?
My oldest...
--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)

July 20, 2011 at 7:14 am

#1355573
RE: Are the posted questions getting worse?

bitbucket-25253 (7/19/2011)
Jeff Moden (7/19/2011)
bitbucket-25253 (7/19/2011)
Having had the pleasure of meeting Jeff Moden, at the speakers / volunteers dinner prior to SQL Sat #60 (Cleveland), let me tell you Jeff is...
--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)

July 19, 2011 at 11:57 pm

#1355367

Viewing 15 posts - 33,196 through 33,210 (of 59,099 total)