Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,691 through 9,705 (of 59,091 total)

RE: Dealing with Technical Debt

RonKyle - Wednesday, March 13, 2019 2:21 PM
Why do so many people think that "doing it right" is at odds with...
--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)

March 13, 2019 at 5:57 pm

#2024393
RE: Dealing with Technical Debt

David.Poole - Wednesday, March 13, 2019 9:56 AM
RonKyle - Wednesday, March 13, 2019 7:30 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)

March 13, 2019 at 2:16 pm

#2024372
RE: trimming SSNs

Another damnable company that has SSNs in clear text. :crazy:
--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)

March 13, 2019 at 2:03 pm

#2024370
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Tuesday, March 12, 2019 3:04 PM
If any of you are interested, we'd love some new articles...
--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)

March 12, 2019 at 10:00 pm

#2024286
RE: Sql Query to find invalid SSN Numbers

glenn.rollins3 - Tuesday, March 12, 2019 11:36 AM
Jeff Moden - Tuesday, March 12, 2019 11:11 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)

March 12, 2019 at 12:00 pm

#2024255
RE: Dealing with Technical Debt

From the article:
Just like financial debt, not all technical debt is bad.

Actually, it's bad on both counts. You always end up paying much 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)

March 12, 2019 at 11:54 am

#2024254
RE: Performance Issue

DBA_007 - Tuesday, March 12, 2019 9:08 AM
Grant Fritchey - Tuesday, March 12, 2019 8:53 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)

March 12, 2019 at 11:19 am

#2024247
RE: Sql Query to find invalid SSN Numbers

Sean Lange - Tuesday, March 12, 2019 8:33 AM
glenn.rollins3 - Tuesday, March 12, 2019 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)

March 12, 2019 at 11:11 am

#2024244
RE: CAST with NUMERIC(12,2) using INT variables

Eirikur Eiriksson - Monday, March 11, 2019 2:16 PM
Jeff Moden - Monday, March 11, 2019 1:13 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)

March 11, 2019 at 2:21 pm

#2024143
RE: Does the Order of Tables in the Join clauses of the Update Statement Matter

Jonathan AC Roberts - Monday, March 11, 2019 9:37 AM
Jeff Moden - Monday, March 11, 2019 9:01...
--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)

March 11, 2019 at 1:26 pm

#2024138
RE: CAST with NUMERIC(12,2) using INT variables

Eirikur Eiriksson - Monday, March 11, 2019 11:30 AM
sgmunson - Monday, March 11, 2019 11:01 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)

March 11, 2019 at 1:13 pm

#2024132
RE: Does the Order of Tables in the Join clauses of the Update Statement Matter

Jonathan AC Roberts - Monday, March 11, 2019 7:52 AM
The optimizer will workout the best order to join the tables. So it...
--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)

March 11, 2019 at 9:01 am

#2024106
RE: sql job taking more time

Personally, I'd go back to the old ways of starting to troubleshoot. First, you have a job that normally takes 6-8 hours to complete and, for me, that would 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)

March 11, 2019 at 6:39 am

#2024079
RE: how to set value of variable = variable + string

polkadot - Sunday, March 10, 2019 11:47 PM
In subject line of email I want @Subject to return "'Submission at 10/03/2019 22:46:34".
Concatenating...
--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)

March 11, 2019 at 6:31 am

#2024077
RE: how to set value of variable = variable + string

I'd recommend that you get out of the habit/crutch of using FORMAT. Yeah... it's nice and easy but it's a bad habit until they fix the major performance issues it...
--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)

March 11, 2019 at 6:20 am

#2024073

Viewing 15 posts - 9,691 through 9,705 (of 59,091 total)