Jeff Moden

Forum Replies Created

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

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
RE: taking very long time to execute

Sean Lange - Monday, April 9, 2018 7:28 AM
Jeff Moden - Friday, April 6, 2018 2:09...
--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:15 am

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

DaveBoltman - Monday, April 9, 2018 4:08 AM
There aren't 365 days in a year. Seeing that hard-coded constant in the code...
--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:13 am

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

@dcs1548 ,
Dividing by 365 is far from accurate, as well, and there's no reason to suffer such inaccuracies especially on date...
--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 8, 2018 at 8:29 pm

#1985915
RE: Stumbling over Words

Great article, Phil. It should be required reading for anyone writing a blog or article or giving a presentation.
I'll also add that articles or blog entries shouldn't be...
--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 8, 2018 at 1:01 pm

#1985908
RE: Table Row Count

VastSQL - Sunday, April 8, 2018 4:53 AM
Hi Experts,
We have a very Large table which hold almost 185GB of data.
When ran...
--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 8, 2018 at 8:33 am

#1985905
RE: Are the posted questions getting worse?

Michael L John - Saturday, April 7, 2018 5:46 PM
A few weeks back, we were all sharing our "can you top this"...
--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 7, 2018 at 5:55 pm

#1985898
RE: SELECTing a hierachy

Apparently, the OP has left the building.
--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 7, 2018 at 5:54 pm

#1985897

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