Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,181 through 6,195 (of 59,101 total)

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
Reply To: Need help to form query to get missing month data

Jeff Moden wrote:
anuxps wrote:
I want to know what are the customers having missing month data based on the following data pattern. My data is present in table in below format. Please...
--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:50 am

#3802299
Reply To: Code to auto-update tables on set date

thetubageek wrote:
OK, it turns out that after meeting with the Development Team, this was a much more complex table design than originally needed. So, I don't need any of 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)

October 28, 2020 at 10:25 pm

#3802273
Reply To: Index question

Admingod wrote:
We have some indexes we have changed over the last few years to address performance problems. Currently the system is in MySql. But we are planning to do 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)

October 28, 2020 at 10:09 pm

#3802272

Viewing 15 posts - 6,181 through 6,195 (of 59,101 total)