Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,166 through 6,180 (of 59,089 total)

Reply To: How to improve the performance of insert?delete?update sql statement

As a bit of a sidebar, if you're updating the proverbial "millions of rows", it may be better to disable most (not the ones that are unique because they may...
--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)

October 30, 2020 at 2:35 pm

#3802836
Reply To: How to improve the performance of insert?delete?update sql statement
892717952 wrote:
as it was said in the title, which we should pay attention to when optimizing insert?delete?update sql statement? thanks
The following points is what I know :
--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)
October 30, 2020 at 1:56 pm

#3802830
Reply To: How to improve the performance of insert?delete?update sql statement

ScottPletcher wrote:
One thing to look out for is UPDATEs that significantly expand the size of varchar columns because that can cause page splits which can be a real performance issue,...
--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)

October 30, 2020 at 1:36 pm

#3802829
Reply To: Index question

Admingod wrote:
Table has around approx 2 million rows over a million column in the index has a single value and the top 3 values overall cover 3/4 of all records....
--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)

October 30, 2020 at 12:53 pm

#3802803
Reply To: Building Quality In

david.edwards 76768 wrote:
Jeff Moden wrote:
In other words, "Make it work, make it fast, make it pretty... and it's not done 'til it's pretty".
Couldn't help be reminded of the old saying: "You can...
--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)

October 30, 2020 at 2:09 am

#3802679
Reply To: Comparing consecutive datetime rows for schedules

Michael L John wrote:
There's a lot here. I'm not sure I am 100% clear about what you are looking for. I will take stab at what I think I understand you are...
--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)

October 30, 2020 at 1:13 am

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

Lynn Pettis wrote:
Steve Collins wrote:
My goal is to come up with questions
Weird, the message above is not the message in the email notification which is this:
My new goal is to come up...
--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)

October 29, 2020 at 9:26 pm

#3802621
Reply To: Setting Rows to Odd and Even Values

Nicely done, Ben. Awesome simplification of an "interleaving" method using some very straight-forward math.
--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)

October 29, 2020 at 6:23 pm

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

Grant Fritchey wrote:
Michael L John wrote:
Is this person in way over their head? It seems like he was dumped in a closet and given orders to find out everything. He's been pretty prolific...
--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)

October 29, 2020 at 5:43 pm

#3802560
Reply To: Comparing consecutive datetime rows for schedules

Michael L John wrote:
mtz676 wrote:
Apologies, I was not clear entirely in my first post.
I got the table result from msdb.dbo.backupset, master.sys.sysdatabases and msdb.dbo.backupmediafamily.
I am trying to draw inference from the results 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)

October 29, 2020 at 5:31 pm

#3802549
Reply To: Comparing consecutive datetime rows for schedules

mtz676 wrote:
Close enough and yes .(excepting the auditors part !) I will post code once I make progress.
I'm not quite sure what you mean by that. Your original post says...
--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)

October 29, 2020 at 5:30 pm

#3802546
Reply To: db size for all db's across servers from cms

mtz676 wrote:
Thanks for the answer..I had it working using table variables in my script and it worked fine.
Two way street here, please. Can you share your code? Someone else might...
--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)

October 29, 2020 at 3:06 pm

#3802477
Reply To: Building Quality In

From the article:
However, that should be a learning and teaching moment. We don't expect continuous quality issues, certainly not of the same type. A big part of the DevOps...
--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)

October 29, 2020 at 2:52 pm

#3802472
Reply To: Comparing consecutive datetime rows for schedules

Ah... yeah. I get what you're trying to do. You're trying to look at "actuals" by database to ensure that the backups are not only following a backup plan but...
--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)

October 29, 2020 at 2:22 pm

#3802460
Reply To: SQL changing what index it uses

Kris-155042 wrote:
But why did it happen in the first place.
Heh... It's not a "Fault"... It's a "Feature" that helps keep DBAs and accidental DBAs employed. 😀
--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)

October 29, 2020 at 1:49 pm

#3802453

Viewing 15 posts - 6,166 through 6,180 (of 59,089 total)