Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,101 through 2,115 (of 59,067 total)

Reply To: The Programming Languages We Use

Eirikur Eiriksson wrote:
He he he, are you selecting the tool before the job? 😎 "when you have a hammer, every task is a nail"
Also remember that when you're trying 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)

January 13, 2023 at 4:24 pm

#4137464
Reply To: The Programming Languages We Use

As a bit of a sidebar, I just watched the day 3 presentation that Kimberly Tripp gave. It seems that really old technology still prevails and that technology is SQL...
--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 13, 2023 at 7:19 am

#4137220
Reply To: Cant extract values from JSON Array

Steve Collins wrote:
The alternative involves custom coding/recoding to and from SQL Server data types, no?
You just wrote custom code on the database side of the house by including INT and NVARCHAR(MAX)...
--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 13, 2023 at 6:31 am

#4137208
Reply To: The Programming Languages We Use

It reminds me a bit of the differences between VHS and Beta tapes. Beta was the better of the two but mostly never got off the ground. Python seems 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)

January 13, 2023 at 3:24 am

#4137175
Reply To: Cant extract values from JSON Array

TBH, I have an extreme dislike for all of the solutions on this thread, not because of how they were coded, but because such code was required to begin with. ...
--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 7:59 pm

#4136997
Reply To: Do Hybrid Conferences Work?

Agreed... thanks for the comments and, Steve/Grant, thanks 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)

January 12, 2023 at 5:57 pm

#4136914
Reply To: Replacing text

Eirikur Eiriksson wrote:
After this question, we can image what question is n(t)ext 😉 😎
😀
I'm going to add this QOD question to my "Litmus Strip" interview questions. I wonder how may people...
--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 5:27 pm

#4136910
Reply To: Cant extract values from JSON Array
Steve Collins wrote:
It's valid JSON. You could try either with two OPENJSON's or one OPENJSON and 2 JSON functions
```
/* two OPENJSON's */
select SerialNumber, ojc.[value] as ChannelID
from openjson(@json) with...
```
--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 5:23 pm

#4136909
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

Viewing 15 posts - 2,101 through 2,115 (of 59,067 total)