Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,891 through 4,905 (of 59,101 total)

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

VSCurtis wrote:
Don't worry about it. I won't be coming back here for help since all you guys want to do is make excuses for a tool that turns a simple...
--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 2:41 am

#3917640
Reply To: Database Triggers

mballentine wrote:
Thank you both. I got it working!
Very cool... can you post the code you used to replace the FORMAT function? 😉
--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 5, 2021 at 12:07 pm

#3917125
Reply To: Database Triggers

And don't use the FORMAT function. Even relatively complicated functionality created by CONVERT is 38 times (in this case) faster than FORMAT. Take the time to figure out the alternative...
--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 5, 2021 at 12:40 am

#3917016

Viewing 15 posts - 4,891 through 4,905 (of 59,101 total)