Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,116 through 2,130 (of 59,082 total)

Reply To: Troubles with in memory OLTP performance degradation

tommiwan wrote:
Due to the nature of the business they shut the servers down each night and turn them back on in the morning through automation.
I have to ask... what "nature...
--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 15, 2023 at 12:00 am

#4137842
Reply To: Cant extract values from JSON Array

ZZartin wrote:
Jeff Moden wrote:
Totally understood on that... but do you suppose that they'll actually use your good code to "normalize the data" and store that normalized data in a database 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)

January 13, 2023 at 9:12 pm

#4137561
Reply To: The Programming Languages We Use

David.Poole wrote:
The most relevant speed to a business is often the speed at which you can deliver business value.
That's always true. The problem with that is the panic that ensues...
--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 5:52 pm

#4137500
Reply To: SQL Query to fill in Null Column values based on closest date to a given date

Maybe I'm still suffering from insufficient caffeine levels this morning, but I have to admit, David, I'm confused. Why did you change the row numbers from what the op originally...
--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:58 pm

#4137484
Reply To: Cant extract values from JSON Array

Totally understood on that... but do you suppose that they'll actually use your good code to "normalize the data" and store that normalized data in a database or store 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)

January 13, 2023 at 4:46 pm

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

Viewing 15 posts - 2,116 through 2,130 (of 59,082 total)