Jeff Moden

Forum Replies Created

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

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
Reply To: Creating a Date Dimension (Calendar Table) in SQL Server

It would appear that most of the code has simply been stolen from the following article...
https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/

--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 14, 2025 at 9:34 pm

#4578965
Reply To: Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

Lordy... I missed your post above, Ron. Great tip. Thanks for posting it and sorry for it taking me nearly two years to acknowledge it.
To add to your good information,...
--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 13, 2025 at 2:31 pm

#4578415
Reply To: Elements of the SQL Server Update Statement

Gosh... SQL Server, MySQL, PostgreSQL, and (finally after decades of not) even Oracle has the ability to do JOINed updates. Consider resubmitting this article with that critical functionality so 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 11, 2025 at 5:01 pm

#4577528
Reply To: Unreliable Narrators

kevin77 wrote:
Eric M Russell wrote:
What we really need is to just stop calling it AI.
Nah... "AI" is the perfect abbreviation but people need to be aware of what it really stands for......
--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 10, 2025 at 1:47 am

#4576381
Reply To: create a table with data capture for next 3 years

This sounds like a good place for monthly partitions. The monthly switch out takes nearly zero time or resources and then the switched out part can just be dropped as...
--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 7, 2025 at 6:47 pm

#4574747
Reply To: Sever Migration

Seems to me that the online documentation should be a better help for 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)

April 7, 2025 at 5:13 pm

#4574704
Reply To: Using Feature Flags

David.Poole wrote:
I
Most of our infrastructure is IAC delivered by a pipeline.
Apologies for not knowing but what does "IAC" stand for in this context?
--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 7, 2025 at 4:51 pm

#4574682
Reply To: Create Raw Zone Tables using Generative AI: The Fabric Modern Data Platform

In my quick look at your article this morning, I may have missed it... are you using the paid version for ChatGPT?

--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 2, 2025 at 1:54 pm

#4571934

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