Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,861 through 4,875 (of 59,089 total)

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

I'm thinking the OP may have gotten an answer from somewhere else and so may no longer be interest in an answer from this thread and certainly not one where...
--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 13, 2021 at 4:06 am

#3919464
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 13, 2021 at 3:18 am

#3919452
Reply To: Index frangmenting

schleep wrote:
Exceptionally busy next few days coming, but I did rebuild this morning, set a trace, and did check once to find 0.04% fragmentation - not the usual leap 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)

August 11, 2021 at 5:24 pm

#3918879
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

Viewing 15 posts - 4,861 through 4,875 (of 59,089 total)