Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,226 through 12,240 (of 59,099 total)

RE: Using FORMAT() for Dates

Yes he did. I've acknowledged that in my posts a couple of times now and is a part of what we're discussing.
--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)

May 26, 2018 at 3:30 pm

#1992062
RE: sql graph query output

Not trying to be difficult here. I'm trying to anticipate your next question after this. 😉
What will you do with the output you require once someone has shown...
--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)

May 26, 2018 at 11:22 am

#1992058
RE: Using FORMAT() for Dates

patrickmcginnis59 10839 - Friday, May 25, 2018 9:59 AM
Jeff Moden - Friday, May 25, 2018 8:35 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)

May 26, 2018 at 12:25 am

#1992045
RE: Using FORMAT() for Dates

Steve Jones - SSC Editor - Thursday, May 24, 2018 4:31 PM
Jeff Moden - Thursday, May 24,...
--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)

May 25, 2018 at 10:42 pm

#1992044
RE: Rebuilding Indexes very often is good?

p.s. Almost forgot... One of the attendees of the presentation called me to say the new methods I've developed will be a real "game changer in the industry" and he's setting...
--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)

May 25, 2018 at 12:59 pm

#1992027
RE: Rebuilding Indexes very often is good?

Eric M Russell - Friday, May 25, 2018 12:19 PM
By default, I typically have a daily job that will REORGANIZE (partitions) having...
--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)

May 25, 2018 at 12:55 pm

#1992026
RE: Using FORMAT() for Dates

ThomasRushton - Friday, May 25, 2018 8:45 AM
Jeff Moden - Thursday, May 24, 2018 3:33 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)

May 25, 2018 at 9:44 am

#1992002
RE: Using FORMAT() for Dates

ThomasRushton - Friday, May 25, 2018 5:20 AM
patrickmcginnis59 10839 - Thursday, May 24, 2018 9:47 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)

May 25, 2018 at 8:35 am

#1991982
RE: Using FORMAT() for Dates

Eirikur Eiriksson - Thursday, May 24, 2018 8:17 AM
Jeff Moden - Thursday, May 24, 2018 8:02 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)

May 24, 2018 at 3:33 pm

#1991923
RE: Using FORMAT() for Dates

Solomon Rutzky - Thursday, May 24, 2018 2:59 PM
Steve Jones - SSC Editor - Thursday, May 24,...
--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)

May 24, 2018 at 3:25 pm

#1991919
RE: Using FORMAT() for Dates

Steve Jones - SSC Editor - Thursday, May 24, 2018 9:25 AM
Jeff Moden - Thursday, May...
--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)

May 24, 2018 at 3:17 pm

#1991918
RE: Using FORMAT() for Dates

Steve Jones - SSC Editor - Thursday, May 24, 2018 9:58 AM
I'll also add that I've worked on lots of systems 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)

May 24, 2018 at 3:07 pm

#1991916
RE: Testing new indexes

alex.palmer - Thursday, May 24, 2018 8:50 AM
That's what my management are scarred of. A process we're not aware of battering 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)

May 24, 2018 at 2:59 pm

#1991914
RE: Testing new indexes

Eirikur Eiriksson - Thursday, May 24, 2018 7:56 AM
Jeff Moden - Thursday, May 24, 2018 6:04 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)

May 24, 2018 at 8:09 am

#1991790
RE: Using FORMAT() for Dates

Eirikur Eiriksson - Thursday, May 24, 2018 7:30 AM
Thom A - Thursday, May 24, 2018 6:03 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)

May 24, 2018 at 8:02 am

#1991789

Viewing 15 posts - 12,226 through 12,240 (of 59,099 total)