Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,281 through 2,295 (of 59,098 total)

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
Reply To: Improving Skills at Work

Xedni wrote:
Problem with learning on one's own [dt]ime is you can really only barely scrape the surface of all these techs going through books and training courses. The ecosystem 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)

December 19, 2022 at 4:14 pm

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

alistair_goodall wrote:
Not sure if anyone is ever coming back to this thread but having just worked on migrating JDE data out and found the above useful - here is 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)

December 19, 2022 at 7:01 am

#4127304
Reply To: Improving Skills at Work

Rod at work wrote:
Most of my IT coworkers aren't even interested in improving their skills on the company nickel. They will only improve their skills if whatever old technology is permanently removed,...
--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 12:19 am

#4127223
Reply To: get a substring value from string

carsten.saastamoinen wrote:
And we can see earlier in this post how some people use tally from a function found on the net, because they have learned, that this is the only...
--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 18, 2022 at 10:46 pm

#4127210
Reply To: Parallel Execution Plan - Or not.

SteveOC wrote:
Interestingly I found that a setting of 8 (vs 6) does speed up the original slow query significantly it testing.
Perhaps it is time to increase the value due 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)

December 18, 2022 at 10:18 pm

#4127201
Reply To: Why are the logical reads appearing in IO STATISTICS even after cleaning Cache

A slightly different way to put it ... I'ts because SQL Server cannot actually use anything directly from Physical Reads. It MUST be loaded into memory before it can be...
--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 18, 2022 at 10:04 pm

#4127197
Reply To: Improving Skills at Work

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 time.
And, if...
--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 18, 2022 at 9:54 pm

#4127196
Reply To: get a substring value from string

carsten.saastamoinen wrote:
Most people are still using a version earlier than 2022! So just using the 2022 version to solve this problem is not the right solution - for some developers...
--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 18, 2022 at 9:32 pm

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

For me, it's very much something that MS got wrong. They're even trying to make it so that the NULL settings are not optional and Front-Enders are ready to march...
--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 18, 2022 at 9:28 pm

#4127192

Viewing 15 posts - 2,281 through 2,295 (of 59,098 total)