Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,236 through 2,250 (of 59,067 total)

Reply To: Updating .NET Core on SQL Server --> Dangerous?

Michael L John wrote:
Jeff Moden wrote:
Thanks for taking the time to post feedback, JJ. It IS interesting to see which hoops and how high the flames are that other people have to 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)

December 20, 2022 at 11:53 pm

#4128169
Reply To: Updating .NET Core on SQL Server --> Dangerous?

Thanks for taking the time to post feedback, JJ. It IS interesting to see which hoops and how high the flames are that other people have to go through.
And glad...
--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 20, 2022 at 11:33 pm

#4128166
Reply To: What's the logic of the NOT IN clause?

jcelko212 32090 wrote:
SQL FOR SMARTIES 5th edition, chapter 18.2 goes into a lot of painful details znd works it all out
Thanks, Joe!
--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 20, 2022 at 11:17 pm

#4128164
Reply To: get a substring value from string

carsten.saastamoinen wrote:
Hopefully 10 seconds few times a day is a problem on you server!!!!
It's not... but the attitude that will cause everything to be written in such a fashion, 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)

December 20, 2022 at 5:09 am

#4127780
Reply To: What's the logic of the NOT IN clause?

jcelko212 32090 wrote:
Yes, that is how NOT IN () is defined in ANSI/ISO Standard SQL.
Thanks for the confirmation on that, Joe. Do you happen to have a link for that 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)

December 20, 2022 at 5:08 am

#4127779
Reply To: Embadded Select in another Select and using apostrophes / quotes
The way I write such code is to ...
1. Write it like normal, properly indented code.
2. Test the dickens out of it to make sure it works.
3. Doe a search...
--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 20, 2022 at 12:23 am

#4127720
Reply To: Embadded Select in another Select and using apostrophes / quotes

You code appears to be a part of Dynamic SQL. If so, then replace each single quote with two single quotes.
--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 19, 2022 at 11:29 pm

#4127709
Reply To: Updating .NET Core on SQL Server --> Dangerous?

I found an update by someone that I personally trust on the subject (to be sure, I also trust Michael but the link below has a "chart" on the subject...
--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 19, 2022 at 11:00 pm

#4127703
Reply To: What's the logic of the NOT IN clause?

Jeffrey Williams wrote:
It seems this thread has gotten off-track.
BWAAA-HAAA!!!! I wonder how that happened. 😀 😀 😀
Jeffrey Williams wrote:
Maybe I am off-base here, but...
And, not to worry... you're not the only one...
--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 19, 2022 at 10:28 pm

#4127690
Reply To: Updating .NET Core on SQL Server --> Dangerous?

I would ask THEM (your Help Desk people) to contact Microsoft and for THEM to take full responsibility if the proverbial poo hit's the fan because of such an upgrade. ...
--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 19, 2022 at 9:00 pm

#4127660
Reply To: Converting from Gregorian to Julian Dates For JDE

SwePeso wrote:
https://www.sqltopia.com/algorithms/date-and-time/jdedwards/
You should have posted those here back in 2009. 😀
I also noticed the note at the bottom of your post... why not write those functions as iTVFs instead 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)

December 19, 2022 at 8:51 pm

#4127656
Reply To: What's the logic of the NOT IN clause?

Eirikur Eiriksson wrote:
Jeff Moden wrote:
Eirikur Eiriksson wrote:
Sam-263310 wrote:
@Eirikur That works, of course, but SQL Server won't be able to use any index for that query.
Using indices is not necessarily the same as having...
--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 19, 2022 at 8:45 pm

#4127652
Reply To: What's the logic of the NOT IN clause?

Eirikur Eiriksson wrote:
Sam-263310 wrote:
@Eirikur That works, of course, but SQL Server won't be able to use any index for that query.
Using indices is not necessarily the same as having better performance,...
--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 19, 2022 at 4:33 pm

#4127565
Reply To: Upskill Azure Data Factory knowledge

Yeah... he came back with an "I got this" post with an embedded link. Took that one out.
--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 19, 2022 at 4:29 pm

#4127550
Reply To: Improving Skills at Work

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
What I've found is that a lot of employees have the proverbial 9-to-5- attitude and only want to improve their skills on the company nickel and on company...
--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 19, 2022 at 4:27 pm

#4127548

Viewing 15 posts - 2,236 through 2,250 (of 59,067 total)