Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,151 through 6,165 (of 59,072 total)

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

jcelko212 32090 wrote:
I did an article called Constraint Yourself! back in October 2008 on how to use DDL constraints to assure data integrity. One of the topics in that piece was...
--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 9:56 pm

#3802261
Reply To: Question about Data Warehouse

RoxyLightning wrote:
Therapists who work for this client must enter their time in the client's system AND our system. I help our billing specialist compare the data from the 2 systems...
--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 2:15 pm

#3802089
Reply To: Need help to form query to get missing month data

ScottPletcher wrote:
I see no need to use a 4 digit year here. Almost no businesses go back and analyze 100-year-old data, so there's no ambiguity. Even more so if 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)

October 28, 2020 at 1:45 pm

#3802082
Reply To: How Long is the List?

Heh... I don't know much about JSON but that's pretty counter intuitive of the language.
Also, I don't know why people are giving this question a low rating. It seems straight...
--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 1:32 pm

#3802079

Viewing 15 posts - 6,151 through 6,165 (of 59,072 total)