Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,541 through 12,555 (of 59,095 total)

RE: Join on field of varying length

daniness - Wednesday, April 18, 2018 1:59 PM
Hi Scott,
Thanks for your reply. I'm not following your code. In this portion:
--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 18, 2018 at 7:02 pm

#1987437
RE: Are the posted questions getting worse?

Jason A. Long - Monday, April 16, 2018 10:00 AM
Jeff Moden - Monday, April 16, 2018 8:58...
--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, 2018 at 8:35 am

#1987159
RE: Removing stored procedures to move to cloud

Eric M Russell - Tuesday, April 17, 2018 7:30 AM
The way I see it, usage of stored procedures actually makes the application...
--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, 2018 at 8:09 am

#1987147
RE: Execution plan missing.

mig28mx - Thursday, April 12, 2018 6:40 PM
Hi all.
Recently I have found with the help of one of the Bent Ozar, scritps....
--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, 2018 at 7:51 am

#1987140
RE: Desperation on the Forums

Marcia J - Monday, April 16, 2018 9:12 PM
Your post reminded me of something that happened my freshman year in college (many,...
--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, 2018 at 7:48 am

#1987139
RE: Removing stored procedures to move to cloud

Shifting gears a bit and to quote Walt Kelly, "We have met the enemy... and he is us". As Steve Jones posted about his son taking computer classes, so we...
--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, 2018 at 7:03 am

#1987132
RE: Removing stored procedures to move to cloud

sgmunson - Tuesday, April 17, 2018 6:32 AM
xsevensinzx - Tuesday, April 17, 2018 6:22 AM
--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, 2018 at 6:45 am

#1987126
RE: Removing stored procedures to move to cloud

funbi - Tuesday, April 17, 2018 6:00 AM
Hugo Kornelis - Tuesday, April 3, 2018 1:50 PM
--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, 2018 at 6:30 am

#1987122
RE: Desperation on the Forums

Steve Jones - SSC Editor - Monday, April 16, 2018 10:12 AM
My kid did a Python course and then another programming 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)

April 17, 2018 at 6:01 am

#1987115
RE: Desperation on the Forums

Sean Lange - Monday, April 16, 2018 9:29 AM
Grant Fritchey - Monday, April 16, 2018 7:29 AM
--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, 2018 at 9:42 am

#1987000
RE: Believing the Data

Eric M Russell - Monday, April 16, 2018 7:35 AM
Machines don't lie, but the data they tell us can still be inaccurate....
--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, 2018 at 9:07 am

#1986977
RE: Are the posted questions getting worse?

Even though spring doesn't seem to be happening this year, I'm still very happy to be in Michigan. No hurricanes. No flooding at all where I live. No raging fires. ...
--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, 2018 at 8:58 am

#1986973
RE: Failure sending mail: Failure sending mail.

dweil - Friday, April 13, 2018 12:16 PM
I'm still waiting on our email administrator.
However, I did find the problem and the fix.
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 15, 2018 at 8:21 am

#1986870
RE: Desperation on the Forums

When I was a kid, I needed money to be able to buy the things I wanted. I found out there was some pretty easy money to be had by...
--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 15, 2018 at 7:18 am

#1986869
RE: Believing the Data

The old saying of "If you make something idiot proof, then only idiots will use it" comes to mind when I think of where we're going with data. Another 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)

April 15, 2018 at 6:41 am

#1986868

Viewing 15 posts - 12,541 through 12,555 (of 59,095 total)