Jeff Moden

Forum Replies Created

Viewing 15 posts - 31 through 45 (of 59,075 total)

Reply To: AllocationType as ROW_OVERFLOW_DATA

To be honest, this all sounds like one of those developers that believes that "Knuth's Parable" about "Preoptimization is the Root of All Evel" means that you never have 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)

February 24, 2026 at 10:48 pm

#4739996
Reply To: Eight Minutes

Heh... you said a mouthful on the "bad" stuff. I actually asked ChatGPT about things like that and it says that it is programmed to basically come up with 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)

January 27, 2026 at 2:01 am

#4724580
Reply To: Eight Minutes

I found a very interesting article... It's interesting for two reasons...
The first is because the writer thinks we're all screwed, especially juniors.
The second is because he says that SQL is...
--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)

January 26, 2026 at 8:50 pm

#4724371
Reply To: Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON

saum70 wrote:
...will be inserted using BCP from VC++ application...
I'm definitely not a front-end kind of guy... When you say "BCP", what are you talking about??? Single row inserts?
The reason I...
--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)

January 26, 2026 at 8:36 pm

#4724364
Reply To: Eight Minutes

Understood on the areas where AI shines.. kinda simple stuff. I'd estimate that more than 90% of the population doesn't get that. They also don't understand what "Silent Failures" 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)

January 26, 2026 at 8:29 pm

#4724346
Reply To: Cumulative Update 23 - KB5074819 - Database Mail - No longer working.

Bob Ward send out a notification on LinkedIn that SQL Server 2022 CU-23 and SQL Sever 2025 CU-1 have a nasty bug in them that does just exactly what 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)

January 22, 2026 at 6:21 pm

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

Neil Burton wrote:
There's a question. I've sent off a few applications but I've not had positive back from any of them. There's not a lot going on at the moment 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)

January 19, 2026 at 12:15 am

#4719985
Reply To: Eight Minutes

I have to admit that I'm seriously concerned about AI, especially but not limited to when it's been asked to do something in SQL.
When it comes to such a thing,...
--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)

January 16, 2026 at 3:22 am

#4717457
Reply To: JSON Has a Cost

I can't see any of the comments that were posted according to the discussion pages near the bottom of the article,

--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)

January 14, 2026 at 6:18 pm

#4716655
Reply To: Large posts full of code not allowed anymore?

frederico_fonseca wrote:
the reason why the code was removed (post deleted really) is because since sometime ago any post that contains 2 URL's gets that treatment. there is no error, just...
--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)

January 13, 2026 at 3:45 am

#4715771
Reply To: CAST datetimeoffset(7) as a datetime in UK format
I hope I'm not too late... simple conversions of DATETIMEOFFSET(7) to DATETIME will cause rounding up to the next unit of time once out of every 600 times... and that...
- This reply was modified 6 months, 4 weeks ago by Jeff Moden. Reason: Forum software kept destroying the post
--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)
January 13, 2026 at 3:27 am

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

Neil Burton wrote:
The timing is less than ideal but that 21 years means I'm going to get quite a significant payout. By my calculations, after tax it's a year's money so...
--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)

January 13, 2026 at 2:29 am

#4715738
Reply To: SQL Server 2025 Backup Compression Algorithm

Hard lessons in the past (especially for but not limited to SQL Server 2012) have "helped" me understand not to trust Microsoft for at least a year (and sometimes more)...
--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)

December 30, 2025 at 2:54 pm

#4709549
Reply To: How Important Are Real Time Decisions?

Like Granny used to say, "The faster they move, the behinder they get".
--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)

December 7, 2025 at 5:00 pm

#4695680
Reply To: What's Your Theme Music?

I did that for the SQL Saturday in Kalamazoo, MI in 2013. I did a take on "Strolling through the park" to introduce my session on how to safely 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)

December 1, 2025 at 6:36 pm

#4692955

Viewing 15 posts - 31 through 45 (of 59,075 total)