Jeff Moden

Forum Replies Created

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

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
Reply To: Import CSV Data Into Existing Tables

Erland Sommarskog wrote:
I'm not sure why Jeff keeps talking about the version of SQL Server. We are not talking about BULK INSERT here.

Because that import flat file thing has been upgraded...
--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:53 am

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

skeleton567 wrote:
Jeff Moden wrote:
Have any of you good folks used the "Automatic Tuning" feature of SQL Server 2016 for on-prem? If so, how'd it work out for you?
I ask because 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 4:46 am

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

VoldemarG wrote:
One of the things we fixed was analyzing waits: tempDb bottleneck (Allocation Pressure).
And how did you fix that?
--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 8, 2021 at 8:32 pm

#3917959
Reply To: Import CSV Data Into Existing Tables

Lynn Pettis wrote:
Reply, SQL Server 2019 and the latest version of SSMS. I changed the length of the output for the media_path column in the import and ensured the length 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)

August 7, 2021 at 8:18 am

#3917725
Reply To: Import CSV Data Into Existing Tables

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 anywhere.
Having had...
--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 7, 2021 at 8:16 am

#3917724
Reply To: Cursor replacement suggestions

The whole reason for the RBAR of a cursor here is so that you can call the Capture_Inline_Quality stored procedure for each and every bloody row. That, good sir, is...
--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 7, 2021 at 4:36 am

#3917654
Reply To: Import CSV Data Into Existing Tables

Lynn Pettis wrote:
FYI made changes in the import wizard and the data imported just fine. I do suggest that when you post a problem, whether here or another site, that you...
--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 7, 2021 at 4:20 am

#3917650
Reply To: is Forced Parameterization usually more beneficial than less?

VoldemarG wrote:
... modifying half a mil ASP web pages ...
I have to ask (as in seriously curious)... you have a half million individually programmed ASP web pages? What kind 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)

August 7, 2021 at 4:16 am

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

Have any of you good folks used the "Automatic Tuning" feature of SQL Server 2016 for on-prem? If so, how'd it work out for you?
I ask because I have 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 7, 2021 at 4:05 am

#3917648

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