Jeff Moden

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 59,067 total)

Reply To: The Data Model Matters

There is definitely some truth to the old adage of "The faster I go, the behinder I get".
It also reminds me of "Love Bug" Season in Florida... going faster in...
--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)

June 5, 2026 at 10:39 pm

#4860940
Reply To: The Data Model Matters

From the article:
Build a strong data model and write efficient SQL Code.
Preach it my brother from a another mother. And great article! Thanks, Steve.
--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)

June 5, 2026 at 5:20 pm

#4860764
Reply To: Running script without having permission to Function

Reh23 wrote:
Unfortunately I do not have permission to execute these functions. Hence I am trying to re-write the Script to enable the core logic of these functions to be incorporated...
--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)

June 3, 2026 at 6:26 pm

#4859746
Reply To: Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now

First and foremost, great article. Thanks for taking the time to put it together.
A bit interesting on the Tally Table reads. I agree that it does cause reads but that's...
--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)

June 3, 2026 at 1:41 am

#4859381
Reply To: The string_agg function

I had no idea about PostGreSQL but I figured it's odd enough for it to work there as a Windowing Function. And, of course, it doesn't work 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)

May 22, 2026 at 12:44 pm

#4845394
Reply To: SSC Spam

The system just got blasted with spam.

--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 7, 2026 at 2:21 pm

#4817814
Reply To: SPAM Issues May 2026

The system just got rapid fire blasted by mulitiple (didn't count them) spams.

--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 7, 2026 at 2:19 pm

#4817793
Reply To: Query compile/runtime issue

"Blocking" could cause this... and it can be for a LONG time.
--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 7, 2026 at 2:13 pm

#4817768
Reply To: The Evolution of AI

Steve Collins wrote:
It's all predicated on the false assumption "a billion flies can't be wrong"
I love it. My term for it is "Corpus Infectious". It's similar to "Bandwagon" that has chicken...
--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 7, 2026 at 1:40 pm

#4817706
Reply To: How do I explain that SQL Server should not be used as a code repository?

The resulting code was more than the 2 billion bytes that could be stored in a VARCHAR(MAX)...
Whoever it is, they need a little training on the BI and, I'll say,...
--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 7, 2026 at 1:26 pm

#4817682
Reply To: SPAM Issues May 2026

I reported one as SPAM this morning, as well.

--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 7, 2026 at 1:15 pm

#4817651
Reply To: T-SQL Trigonometric Functions in SQL Server

Really nice article that explains the "FLOAT problem", Imran2629. Thanks for taking the time to put it together,
It's amazing to me that MS apparently hasn't figured out how to use...
--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 1, 2026 at 3:10 pm

#4784274
Reply To: Half of All Engineers

I wonder why people think that "moving slower" is a bad thing.
The good part about that is, they're going to need people to fix the stuff that the companies 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)

May 1, 2026 at 2:29 pm

#4784207
Reply To: data compare between 2 tables with same structure for any changes after etl run

syam.tunuguntla wrote:
i have huge table with lot of data and is also wide. i took a backup of it before procedure is run in test environment. now i am trying...
--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, 2026 at 5:11 pm

#4777943
Reply To: that one limitation in replication

Do you have a unique Clustered Index or Non-Clustered Index on the table or a column that could take one. If the answer is "Yes", at a PK constraint to...
--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, 2026 at 4:52 pm

#4777927

Viewing 15 posts - 1 through 15 (of 59,067 total)