Jeff Moden

Forum Replies Created

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

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
RE: Rebuilding Indexes very often is good?

simon.evans 66088 - Thursday, May 24, 2018 6:00 AM
Hi Jeff,
When and where will the presentation be, I'm very interested also, but...
--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 6:51 am

#1991772
RE: Using FORMAT() for Dates

Eirikur Eiriksson - Thursday, May 24, 2018 5:43 AM
Jeff Moden - Thursday, May 24, 2018 5:21 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 6:47 am

#1991771
RE: Testing new indexes

alex.palmer - Thursday, May 24, 2018 2:37 AM
Hi
I'm looking for ideas\opinions\experience when it comes to testing new indexes.
Previously I've been able to...
--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 6:04 am

#1991767
RE: Using FORMAT() for Dates

Nice write-up but, even with the warnings, I'm reminded of people that justify poor programming techniques or functionality because of low row counts. It's a bit like teaching people how to...
--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 5:21 am

#1991759

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