Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,706 through 9,720 (of 59,099 total)

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
RE: Alternate Query for better performance

Sangeeth Raj - Monday, March 11, 2019 2:38 AM
Jeff Moden - Sunday, March 10, 2019 3:24 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 6:13 am

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

Clocker - Friday, March 8, 2019 4:17 PM
the result is correct. by convention whole numbers(integers) are not padded with leading zeros, decimals...
--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 10, 2019 at 3:29 pm

#2024046
RE: Alternate Query for better performance

The tables are backwards on this one. The detail table rows should have a reference to the header table, not the other way around.
--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 10, 2019 at 3:24 pm

#2024045
RE: Creating a Stored Procedure

Steve Jones - SSC Editor - Friday, March 8, 2019 2:34 PM
Jeff Moden - Thursday, March 7,...
--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 10, 2019 at 2:37 pm

#2024044
RE: query plans drive off the cliff

tcronin 95651 - Thursday, March 7, 2019 1:00 PM
query plans drive off the road. Have 3rd party app db users complained...
--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 10, 2019 at 2:08 pm

#2024043
RE: Querry

aferhouh - Saturday, March 9, 2019 10:16 PM
Hi there all
Please I need to to have a Query that wourld show how many...
--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 10, 2019 at 2:01 pm

#2024042
RE: Query a dynamic date range based off current month

Clocker - Friday, March 8, 2019 3:42 PM
I would probably opt for a set based approach where you create a list of...
--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 10, 2019 at 1:55 pm

#2024041

Viewing 15 posts - 9,706 through 9,720 (of 59,099 total)