Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,721 through 9,735 (of 59,099 total)

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
RE: Common Data Challenges

Nothing has changed with the data itself when it comes to problems.
What has changed is the frequency of those problems and the desperate hacks people try to hammer...
--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 8:07 am

#2023830
RE: Public Facebook group for peer to peer mental illness support

Man, my heart goes out to you and others on these problems.
--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 7:57 am

#2023825
RE: How does the target table size impact the insert performance

One more thing to add... IF you're using SET IDENTITY_INSERT tablename ON, then THAT's the problem with performance. It's a well know fact (and there is a posted plea 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 7, 2019 at 7:48 am

#2023822
RE: access to colum while is updating

Without seeing the code you're using, we'd only be guessing.
--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 7:44 am

#2023820
RE: How does the target table size impact the insert performance

First, let's clear up the notion about reducing logging... the only way that you can reduce logging during INSERT/SELECT is if a bunch of things happen...
1. The database...
--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 7:42 am

#2023818
RE: Creating a Stored Procedure

Steve Jones - SSC Editor - Thursday, March 7, 2019 7:11 AM
I agree. I'm only doing these questions so people are aware...
--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 7:18 am

#2023811
RE: query regarding compare-object output

I guess my question would be, why aren't you using T-SQL to do this?
--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 7:05 am

#2023805

Viewing 15 posts - 9,721 through 9,735 (of 59,099 total)