Jeff Moden

Forum Replies Created

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

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
RE: Calculate the median

I've not tested it personally but the OFFSET/FETCH option that came out in 2012 seems to be both the most effecient and fastest method. Please see the following article written...
--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:39 pm

#2024040
RE: Creating a Stored Procedure

David Burrows - Friday, March 8, 2019 1:59 AM
Jeff Moden - Thursday, March 7, 2019 4:25 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 9, 2019 at 8:02 pm

#2024027
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Ah... sorry, Alan. I flat out missed (even though bolded and underlined :blush:) that folks were talking about "memory optimized" tables. I can't speak to that because I don't...
--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 9, 2019 at 7:54 pm

#2024026
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Alan.B - Thursday, March 7, 2019 7:50 PM
Luis Cazares - Thursday, March 7, 2019 6:32 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 8, 2019 at 9:33 am

#2023953
RE: query regarding compare-object output

Namrish - Thursday, March 7, 2019 7:40 AM
No Sir..Because I am fetching file1.txt details from another server.
That doesn't mean that you have 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)

March 7, 2019 at 5:10 pm

#2023904
RE: Creating a Stored Procedure

BTW... I've said it in the past and I have to say it again... Thank you, Mr. Jones, for all that you've done and continue to do for the denizens...
--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 7, 2019 at 4:25 pm

#2023901
RE: Creating a Stored Procedure

Steve Jones - SSC Editor - Thursday, March 7, 2019 9:39 AM
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 7, 2019 at 4:23 pm

#2023900
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

drew.allen - Thursday, March 7, 2019 8:49 AM
Jeff Moden - Thursday, March 7, 2019 6:39 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 7, 2019 at 4:12 pm

#2023899

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