Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 59,072 total)

Reply To: Query fails on Developer edition but not Standard since updating to SQL2019

steal wrote:
Interesting article, thank you. The error returned 1 for the state.
Our dev team updated the code that generates the EF query, and that has resolved the problem (so 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)

July 19, 2023 at 4:05 pm

#4239293
Reply To: Need to find max items within each set

migurus wrote:
Thank you very much, it works
Thank you for the feedback!
--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 18, 2023 at 11:41 pm

#4238664
Reply To: Need to find max items within each set

Phil Parkin wrote:
The SQL code is not all uppercase when viewed on my browser (Chrome):
Interesting. Thanks for the feedback, Phil.
--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 18, 2023 at 11:40 pm

#4238663
Reply To: Need to find max items within each set

The last group of data in your example data looks like this...
,(2,7, 210,1)
,(2,8, 211,1)
,(2,9, 212,1)
,(2,10,212,-1)
,(2,11,211,-1)
,(2,12,212,-1) --<---<<< LOOK HERE!
Shouldn't that last line have an Order_ID of 210 instead...
--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 18, 2023 at 3:48 am

#4237782
Reply To: Need to find max items within each set

Deleted... I misread the problem.
--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 18, 2023 at 1:26 am

#4237696
Reply To: Keep your Resume Reasonable

carl.gregory wrote:
The company hired him was looking for forecasting. I'm not sure how it ended, but I know the company was upset with him.
Didn't they interview him? Given the choice,...
--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 18, 2023 at 12:54 am

#4237687
Reply To: Keep your Resume Reasonable

skeleton567 wrote:
Jeff, I honestly don't remember what my answer was. but I'll add this: Today my answer would be :
"If I ever get out of this silly-assed meeting I'll go...
--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 18, 2023 at 12:49 am

#4237685
Reply To: below script with STUFF function executes 2014 but not in 2019 version

Same indexes on both?
Same MAXDOP on both?
Same Cost Threshold For Parallelism?
Same hardware?
There's a shedload of things that could be causing the 2019 code to be running slower and the list...
--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 17, 2023 at 4:15 pm

#4237378
Reply To: SQL Resources/Courses Suggestions

gulshan212 wrote:
Well, since few days I was searching about SQL courses to become pro on this. One of my friend suggest me some guide to become pro on this 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)

July 16, 2023 at 11:13 pm

#4236787
Reply To: Keep your Resume Reasonable

skeleton567 wrote:
My most valuable lesson in the area of resumes and touting accomplishments came from a meeting with the president and co-owner of the company I worked for in 1974. ...
--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 16, 2023 at 8:54 pm

#4236714
Reply To: getting next date

Jonathan AC Roberts wrote:
Yes, we both should have noticed that, but our methods are more general in that they will return the entire row that contains the max date even if some...
--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 16, 2023 at 7:10 pm

#4236670
Reply To: getting next date

SwePeso wrote:
I just realized that both Jonathans and Jeffs queries used all 8 cores and mine just used 1 core. So here is the same query with parallell plan
As 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)

July 16, 2023 at 7:06 pm

#4236669
Reply To: getting next date

What's more interesting than any of that is how we missed the forest for the trees. 🙁 The MAX solution that Peter provided is all that's needed here. [headdesk].
--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 16, 2023 at 3:02 pm

#4236558
Reply To: How to Improve Database Design to Speed Up SQL Queries

Zidar wrote:
I agree with Jeff 100%. Performance is paramount, assuming the foundation is sound. Bot fast and safe at the same time is an ultimate goal, but at 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)

July 16, 2023 at 2:56 pm

#4236551
Reply To: How to Improve Database Design to Speed Up SQL Queries

Zidar wrote:
We are not designing databases for speed, we are doing it to ensure data integrity. What is the use for data retrieved quickly if it is inaccurate or could...
--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 14, 2023 at 3:32 pm

#4235175

Viewing 15 posts - 1,291 through 1,305 (of 59,072 total)