Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,876 through 4,890 (of 59,101 total)

Reply To: Need counts of payment amounts per week grouped by week

joewhite wrote:
Hello,
I have a code that suppose to give me weekly(summed) payments, but instead, it gives me random points, not (1*7, 2*7,...)
I suspect it maybe because it doesn't include 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)

August 11, 2021 at 5:19 pm

#3918877
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

tellery_frmt wrote:
Hi Jeff.
your tally table approach to parsing is the best i've seen. i have a real world problem; wondering if you have any thoughts.
i need to parse a large...
--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)

August 11, 2021 at 5:10 pm

#3918874
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Steve Collins wrote:
There are some caveats to that should've been mentioned. The string is declared as NVARCHAR(MAX) because I don't know that that's not appropriate. The ordinal splitter is name '%8K_LEAD'...
--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)

August 11, 2021 at 2:52 pm

#3918819
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

tellery_frmt wrote:
Thank you, Steve. greatly appreciated!
Ah, be careful. He may not be correct here.
--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)

August 11, 2021 at 2:50 pm

#3918818
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Sean Lange wrote:
tellery_frmt wrote:
Hi Jeff.
your tally table approach to parsing is the best i've seen. i have a real world problem; wondering if you have any thoughts.
i need to parse a...
--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)

August 11, 2021 at 2:49 pm

#3918817
Reply To: Index frangmenting

schleep wrote:
FWIW: This is not a end of the world scenario - this is a rarely used - 1 select every few minutes or so.
I just got curious when I...
--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)

August 9, 2021 at 7:46 pm

#3918248
Reply To: Are the posted questions getting worse?

Michael L John wrote:
Jeff Moden wrote:
Grant Fritchey wrote:
Jeff Moden wrote:
Thanks for the feedback, Grant. I am concerned. While I wouldn't expect such a thing to be "radical" in a test and development environment, seeing "some"...
--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)

August 9, 2021 at 7:32 pm

#3918245
Reply To: Index Type Limits

Still not quite right. The MAX datatypes (LOBs) ARE actually allowed in RowStore indexes. They're allowed in INCLUDEs, just not as a key.
--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)

August 9, 2021 at 4:08 pm

#3918188
Reply To: Import CSV Data Into Existing Tables

@vscurtis...
Still waiting to hear which version of SQL Server you're using.
--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)

August 9, 2021 at 4:03 pm

#3918186
Reply To: Index frangmenting

First, what index level are you looking at in sys.dm_db_index_physical stats? If it's not level "0" and it's not "IN ROW DATA", you can mostly forget about it.
Before we move...
--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)

August 9, 2021 at 3:46 pm

#3918179
Reply To: Index frangmenting

p.s. I contacted the Web Master to restore the post I accidentally hit "Report" on .
--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)

August 9, 2021 at 3:39 pm

#3918177
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
Jeff Moden wrote:
Thanks for the feedback, Grant. I am concerned. While I wouldn't expect such a thing to be "radical" in a test and development environment, seeing "some" thrash and...
--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)

August 9, 2021 at 3:24 pm

#3918165
Reply To: Cursor replacement suggestions

"It Depends". If it also calls stuff in a RBAR fashion, then not really. Someone needs to define what it's supposed to do and then create a new stored procedure...
--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)

August 9, 2021 at 3:19 pm

#3918163
Reply To: Index frangmenting

Crud. My apologies. I hit "report" on your last post by mistake and it doesn't provide an "are you sure question".
Anyway, you said...
It's coming from Table - Indexes - Reorganize....
--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)

August 9, 2021 at 3:11 pm

#3918160
Reply To: Are the posted questions getting worse?

Thanks for the feedback, Grant. I am concerned. While I wouldn't expect such a thing to be "radical" in a test and development environment, seeing "some" thrash and having 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)

August 9, 2021 at 3:02 pm

#3918155

Viewing 15 posts - 4,876 through 4,890 (of 59,101 total)