Jeff Moden

Forum Replies Created

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

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
Reply To: Index frangmenting

schleep wrote:
So, the trigger has been in place, but has not fired. It's simple: On I/U/D, send me an email with the user_name().
I rebuilt the index on Friday morning, 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)

August 9, 2021 at 2:47 pm

#3918153
Reply To: Seeking advice on TOP 10 WAITS and their reduction

Am i correct in assuming that you didn't actually identify the code that was causing the contention or, if you did, that you spent little time trying to figure out...
--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 5:57 am

#3918013
Reply To: Import CSV Data Into Existing Tables

frederico_fonseca wrote:
Jeff Moden wrote:
Understood on the SSIS thing but the Op wasn't using SSIS. For that matter, I typically try to make it so that I never have to use SSIS...
--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 5:01 am

#3918005

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