Jeff Moden

Forum Replies Created

Viewing 15 posts - 61 through 75 (of 59,063 total)

Reply To: How to optimize queries using AI (SQL Expert)
Heh... all that and it still left a temporal BETWEEN instead of using the more correct and bullet proof "Closed/Open" comparison method...
```
... 
  WHERE soh.OrderDate >=...
```
--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)
July 28, 2025 at 9:15 pm

#4627978
Reply To: Comparing one record within a SELECT SUM()
Pete Bishop wrote:
SELECT SUM([value]) AS [value], {some magic code} FROM [table1]
value is_processed
39.6 Y
```
--===== Because 'Y' is greater than 'N', this works.
 SELECT...
```
--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)
July 28, 2025 at 9:03 pm

#4627977
Reply To: In Praise of Simplicity or The Power of Plain Language in a Buzzword World

THIS!!! (from the article)...
Plain language isn’t a lack of sophistication; it’s a sign of mastery.
--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)

July 22, 2025 at 3:59 pm

#4625777
Reply To: Formatting Dates and Times: The SQL Dialect Divide

Just a bit of a sidebar... avoid using FORMAT except for maybe 1 row displays. Performance of FORMAT is absolutely horrible even compared to relatively complex CONVERTs. Here's an 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)

July 22, 2025 at 3:52 pm

#4625773
Reply To: The Long Weekend

Heh... I'm with ya. My git'up'n'go has got up and went. Hope you had a pleasant weekend, Grant.

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

July 6, 2025 at 11:08 pm

#4618533
Reply To: Independence Day

The missing 5th choice, of course...
"All of them"
Happy Independence Day to all!
--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)

July 4, 2025 at 12:08 am

#4617313
Reply To: Error: There was a problem subscribing.

It's not happening to me. I'm not getting the error. I'm also not seeing the "Subscribe" button change to "Unsubscribe" either.
And, as soon as I said that, I hit "Subscribe"...
--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)

July 1, 2025 at 5:24 pm

#4616185
Reply To: Finding Heaps

GREAT question, 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)

July 1, 2025 at 5:13 pm

#4616183
Reply To: The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

How many core did the system you tested this on have?
--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 23, 2025 at 7:49 pm

#4612111
Reply To: Crosstabs and Pre-Aggregations - Reporting on Steroids by Jeff Moden

SwePeso wrote:
Please send me a pdf if possible.
The pre-aggregation sounds familiar
It should sound familiar. You've reviewed this slide deck before. I've made some modifications but, as before, I've mentioned 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)

June 16, 2025 at 10:56 pm

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

This post is just a test to see what the response time of processing a post is now...

--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 16, 2025 at 10:51 pm

#4608631
Reply To: average duration increasing inline with exec counts

simon_s wrote:
As the title says , I've got a handful of stored procs where the avg duration rises and falls pretty much mirroring the exec count. I've looked to see...
--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 13, 2025 at 2:35 pm

#4607139
Reply To: How do I add all the values in the column considering it to be in hh:mm:ss:ms

satnam.singh 44358 wrote:
How do I add all the values in the column considering it to be in hh:mm:ss:ms
Please help.
WHAT is the datatype of the column? If it's character based, what 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)

June 13, 2025 at 2:26 pm

#4607127
Reply To: Helping Students with a Data Professional Career

One of the things that most courses do NOT teach is how to rapidly create Random Constrained Data in the form of test tables and, perhaps, significant row counts of...
--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 4, 2025 at 8:41 pm

#4602707
Reply To: what etl tool are folks moving toward?

Bump to overcome the new-page post missing bug with this site.
--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 21, 2025 at 2:10 am

#4594359

Viewing 15 posts - 61 through 75 (of 59,063 total)