Jeff Moden

Forum Replies Created

Viewing 15 posts - 121 through 135 (of 59,099 total)

Reply To: Interview Tips

Eric M Russell wrote:
I think it's important to familiarize with the current boilerplate questions that are trending on social media, not because these are actually great questions I would personally ask when...
--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)

May 6, 2025 at 1:49 am

#4588099
Reply To: T-SQL Parent Child

Your dbo,starui_country_mastergroup_subgroup table appears to be missing some rows compared to the example you gave, as well.
Please fix your script.
--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)

May 6, 2025 at 1:45 am

#4588098
Reply To: T-SQL Parent Child

I'm hoping that the errors in your attached script aren't going to matter... also, the code you posted above doesn't run due to all of the errors in that.
Msg...
--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)

May 6, 2025 at 12:42 am

#4588095
Reply To: Is SQL Server Feature Complete?

No... it's not "feature" complete. First, I don't know what they heck they did to it but there was a massive slowdown when 2019 came out and it's still slow...
--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)

April 28, 2025 at 12:58 am

#4584785
Reply To: Just a rant about the SQL Server 2022 upgrade

cphite wrote:
How in the heck does something like this get past QA?
From what I've seen over the years with SPs, CUs, and new releases, I'm starting to thing 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)

April 24, 2025 at 9:20 pm

#4583750
Reply To: Size of DB on physical disk doesn't match Disk Usage by Table report

The "Used but Unallocated Space" is usually because of a "wonderful" feature known as "Fast Inserts". It is meant to provide a performance gain when doing inserts containing a huge...
--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)

April 24, 2025 at 9:18 pm

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

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
If you look at the code I posted, the text to describe what happens says that "When the fractional precision of the datetime2(n) value is greater than three...
--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)

April 23, 2025 at 5:48 pm

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

jasona.work wrote:
Anyone noticing a round of replies to posts that "feel" suspiciously like someone fed the OP's question into one of the chat-bot AIs and posted the "answer"?
Yes... especially due...
--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)

April 23, 2025 at 5:26 pm

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

Brandie Tarvin wrote:
It's the middle of the night and I'm online for "reasons."
Looking at your link, Jeff, somebody didn't proofread their code or didn't care. Samples 1 & 4 are identical...
--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)

April 17, 2025 at 10:19 pm

#4580714
Reply To: Creating a Date Dimension (Calendar Table) in SQL Server

MMartin1 wrote:
Plagarism , not cool.
Just to still make a note. I find the ISO_week property interesting.
select datepart(iso_week, '2025-03-30') select datepart(week, '2025-03-30')
Maybe we need an article on this topic.
It's the same...
--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)

April 15, 2025 at 8:49 pm

#4579503
Reply To: Need help with Cut off time in SQL

hollyanneu2 wrote:
Hi,
Need this DAX covert SQL T-SQL.
Ticket Cutoff Status = VAR TimeOnly = TIME(HOUR([Remedy Submitted Date]), MINUTE([Remedy Submitted Date]),
SECOND([Remedy Submitted Date])) RETURN SWITCH( TRUE(), TimeOnly < TIME(13, 0, 0), "Prior...
--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)

April 15, 2025 at 8:37 pm

#4579502
Reply To: How Much AI Code Would You Use?

When would you say it's ok in just about any kine of business where it's OK for dates and times to round up to the day, week, month, quarter, or...
--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)

April 15, 2025 at 8:19 pm

#4579496
Reply To: Find all records in a table whose values when summed up will equal another value

ScottPletcher wrote:
My function by default returns all matches, but you have options to prioritize fewer rows matching or more rows matching.
So post it.
--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)

April 15, 2025 at 8:16 pm

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

Thom A wrote:
jasona.work wrote:
Anyone noticing a round of replies to posts that "feel" suspiciously like someone fed the OP's question into one of the chat-bot AIs and posted the "answer"?
It's not...
--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)

April 15, 2025 at 8:07 pm

#4579494
Reply To: What's the Edge Case?

My favorite "Edge Case" is in the conversion of a DATETIME2 with a given resolution to a DATETIME2 of lower resolution or even DATETIME. When is it "OK" for 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)

April 15, 2025 at 7:52 pm

#4579475

Viewing 15 posts - 121 through 135 (of 59,099 total)