Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,146 through 2,160 (of 59,099 total)

Reply To: Replacing text

+1 MILLION for including the NVARCHAR(8000) answer, Steve! The results there are absolutely astonishing. Lordy!
--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 12, 2023 at 1:03 am

#4136605
Reply To: Error using python in SQL2022: DLL load failed on import: pylink and px_call

Eirikur Eiriksson wrote:
Jeff Moden wrote:
Heh... Had to laugh...I was just thinking that "Revo-Scalepy" (revo-sca-lepy) might make a great name for a line of blenders and food processors. 😀 😀 😀
"Reco-sca-lepy" would 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)

January 11, 2023 at 6:02 pm

#4136528
Reply To: When does the AWS Free Tier ACTUALLY expire?

Grant Fritchey wrote:
Jeff Moden wrote:
Grant Fritchey wrote:
Honestly, no way to be certain. While I enjoy working with the AWS technology, AWS billing is insane. Despite deleting everything that I can find on 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)

January 11, 2023 at 6:00 pm

#4136526
Reply To: Do Hybrid Conferences Work?

Grant Fritchey wrote:
Jeff Moden wrote:
Gosh... I wouldn't blame the "current level of technology" for any such complaints that Steve has cited. That's not the issue.
It's not ALL the problem, but it's part...
--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 11, 2023 at 5:58 pm

#4136519
Reply To: When does the AWS Free Tier ACTUALLY expire?

Grant Fritchey wrote:
Honestly, no way to be certain. While I enjoy working with the AWS technology, AWS billing is insane. Despite deleting everything that I can find on one of my...
--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 11, 2023 at 3:10 pm

#4136455
Reply To: Do Hybrid Conferences Work?

Gosh... I wouldn't blame the "current level of technology" for any such complaints that Steve has cited. That's not the issue.
--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 11, 2023 at 3:07 pm

#4136454
Reply To: Starting a new FileTable

I've not used "File Table" but I want to say "Thank you" for taking the time to share what you're doing. You've always been one of the "good guys" on...
--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 11, 2023 at 4:26 am

#4136237
Reply To: ISNULL in case statement
ScottPletcher wrote:
ISNULL/COALESCE is not as clear as explicitly checking for NULL:
```
SELECT COL1,
CASE WHEN Table1.COL2 = 0 then 'ZERO'
WHEN Table1.COL2 = 1 OR Table1.Col2 IS NULL then 'ONE'
ELSE...
```
--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 11, 2023 at 2:28 am

#4136217
Reply To: Invoke a Tableau dataset refresh from a SQL Agent Job
I know almost nothing of Tableau, so just a couple of thought-provoking ideas.
1. Couldn't you have the Tableau Timer check to see if an "ItsDone.txt" file contains a certain file...
--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 11, 2023 at 2:18 am

#4136216
Reply To: Error using python in SQL2022: DLL load failed on import: pylink and px_call

Heh... Had to laugh...I was just thinking that "Revo-Scalepy" (revo-sca-lepy) might make a great name for a line of blenders and food processors. 😀 😀 😀
--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 11, 2023 at 2:13 am

#4136215
Reply To: average of percentage

sqlenthu 89358 wrote:
Jeff Moden wrote:
sqlenthu 89358 wrote:
Hi Steve, thanks but what you are providing here is calculating percentage. My ask is to get an average of 4 month percentage (or 5 or 6...
--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 10, 2023 at 6:03 pm

#4136045
Reply To: Step functions trigger rule

Looks like Frederico was ultimately correct.
--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 10, 2023 at 12:54 am

#4135725
Reply To: The Time Conversion

Eirikur Eiriksson wrote:
TRY_CAST can be useful for simplifying error handling as it returns NULL rather than raising an error. 😎
Agreed but I've also found that it makes people complacent about...
--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 9, 2023 at 4:49 pm

#4135565
Reply To: The Time Conversion

sknox wrote:
This is a very good reminder that data validation is not just limited to the straight format.
Yep... I totally get that but this is one of those places where...
--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 9, 2023 at 4:29 pm

#4135549
Reply To: Update CR LF in the string as empty

Saran wrote:
CR LF is breaking my data load into mysql, I have updated CR LF as space ' ' and load is working good.
To Frederico's point, it may be 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)

January 9, 2023 at 4:24 pm

#4135547

Viewing 15 posts - 2,146 through 2,160 (of 59,099 total)