Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,571 through 12,585 (of 59,102 total)

RE: Avoiding Unexpected Results with DATEDIFF in Year Comparisons

GeorgeCopeland - Wednesday, April 11, 2018 7:34 AM
Paw Jershauge (Orifarm) - Wednesday, April 11, 2018 6:42 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 11, 2018 at 7:39 am

#1986353
RE: Avoiding Unexpected Results with DATEDIFF in Year Comparisons

Paw Jershauge (Orifarm) - Wednesday, April 11, 2018 6:42 AM
GeorgeCopeland - Wednesday, April 11, 2018 6:32 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 11, 2018 at 7:23 am

#1986345
RE: Removing stored procedures to move to cloud

p.s. Just to be clear, the current team didn't cause the 400TB logical read problem. They were a major factor in fixing that problem (problems, actually).
--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 10, 2018 at 10:41 pm

#1986255
RE: Removing stored procedures to move to cloud

xsevensinzx - Tuesday, April 10, 2018 7:21 AM
That works too. Not to distort the issue as being tied specifically to stored procs....
--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 10, 2018 at 10:28 pm

#1986254
RE: Removing stored procedures to move to cloud

patrickmcginnis59 10839 - Tuesday, April 10, 2018 10:22 AM
Jeff Moden - Tuesday, April 10, 2018 9:54 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 10, 2018 at 9:47 pm

#1986251
RE: Removing stored procedures to move to cloud

patrickmcginnis59 10839 - Tuesday, April 10, 2018 7:53 AM
We just did something smaller and the effects are devastating. The Developers and 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)

April 10, 2018 at 9:54 am

#1986167
RE: Removing stored procedures to move to cloud

xsevensinzx - Tuesday, April 10, 2018 6:25 AM
Jeff Moden - Monday, April 9, 2018 10:32 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 10, 2018 at 7:05 am

#1986110
RE: Removing stored procedures to move to cloud

Why does anyone think that stored procedures are a bottleneck in the development cycle? The Developer writes a proc and it gets promoted at the same time other code does. ...
--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 9, 2018 at 10:32 pm

#1986058
RE: Removing stored procedures to move to cloud

patrickmcginnis59 10839 - Monday, April 9, 2018 1:21 PM
Jeff Moden - Saturday, April 7, 2018 12:39 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 9, 2018 at 9:48 pm

#1986055
RE: Stumbling over Words

Jason A. Long - Monday, April 9, 2018 12:21 PM
Jeff Moden - Monday, April 9, 2018 11:25...
--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 9, 2018 at 5:46 pm

#1986049
RE: Avoiding Unexpected Results with DATEDIFF in Year Comparisons

DBA4482 - Monday, April 9, 2018 2:17 PM
I appreciate you all taking the time to read this article and provide 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)

April 9, 2018 at 5:42 pm

#1986048
RE: Avoiding Unexpected Results with DATEDIFF in Year Comparisons

trevor.adams - Monday, April 9, 2018 7:38 AM
So the coping strategies are
1) A function such as (advantage - it will be correct...
--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 9, 2018 at 11:33 am

#1986003
RE: Avoiding Unexpected Results with DATEDIFF in Year Comparisons

zechstarks - Monday, April 9, 2018 9:02 AM
You would actually want to divide by 365.25, not 365.0, if you want a more...
--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 9, 2018 at 11:31 am

#1986002
RE: Stumbling over Words

jay-h - Monday, April 9, 2018 7:01 AM
This absolutely addresses a real problem. One thing that is often missing from tech docs...
--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 9, 2018 at 11:25 am

#1985999
RE: Is the DBA Title Dying?

HighPlainsDBA - Monday, April 9, 2018 10:29 AM
I hate the title. It's a 60's era moniker that hasn't kept up with 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)

April 9, 2018 at 11:17 am

#1985996

Viewing 15 posts - 12,571 through 12,585 (of 59,102 total)