Jeff Moden

Forum Replies Created

Viewing 15 posts - 886 through 900 (of 59,091 total)

Reply To: Cant extract values from JSON Array

Steve Collins wrote:
Bump. Maybe the prior posting was never visible
This site has had the problem of not posting the 1st post on subsequent pages until an additional post is made for...
--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 14, 2023 at 8:26 pm

#4346094
Reply To: Arctic Wolf flooding SQL error log

Perhaps call the folks at Arctic Wolf and ask what they suggest? Maybe their website has some amplifying information?
--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 14, 2023 at 8:22 pm

#4346093
Reply To: emergency!!! RecoveryPending how to fix it?

Gosh... there are a whole lot of reasons why such a thing may have happened. The first thing I'd do it hit the "REFRESH" in the Object Explorer window and...
--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 14, 2023 at 8:18 pm

#4346092
Reply To: JSON data with Pivoted

Tava wrote:
Actually, Just thinking out loud! Wouldn't a user defined table type (UDT) work in this scenario
It would also eliminate needing the complexity of the JSON be parsed through and...
--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 14, 2023 at 6:43 am

#4345688
Reply To: Query

Ok... the OP is a "No show" on the bit of extra information that I asked. Moving 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)

December 14, 2023 at 5:06 am

#4345632
Reply To: JSON data with Pivoted

Steve Collins wrote:
On this particular topic I disagree with Jeff and I think Phil/me have the right approach.
Understand that I was speaking only from the SQL Server side... there is no...
--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 14, 2023 at 5:04 am

#4345631
Reply To: housekeeping of millions of records on everyday basis

Weekly or monthly partitions is probably the way to go. There are a LOT of caveats to partitioning spread quite wide in the MS documentation. Make sure you read and...
--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 14, 2023 at 4:56 am

#4345612
Reply To: Small Transactional Table with Frequent Updates

Johan Bijnens wrote:
Jeff Moden wrote:
Ladies and gentlemen, the OP has left the building! 😀
Interesting .... you must have pushed to hard to educate.
Such a shame ... especially when someone is willing 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 13, 2023 at 6:16 pm

#4345355
Reply To: Backing Up Master

Heh... as with a lot of things, the correct answer is "The MS Documentation on the subject is not clear on this subject". 😉
It reminds me of the documentation 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)

December 13, 2023 at 4:45 pm

#4345307
Reply To: Query

Jonathan AC Roberts wrote:
Paste it into Excel and create a line chart then add a trend line.
Yeah... I was going to suggest that, as well. Then I remembered how many databases some...
--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 13, 2023 at 4:12 pm

#4345273
Reply To: Memory Usage data capture

mtz676 wrote:
I would like to know the memory consumption distribution(SQL & NON-SQL) at the time the alert occurs. If it is is sql then what within sql is causing it...
--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 13, 2023 at 2:55 pm

#4345241
Reply To: Query
mtz676 wrote:
ServerName DatabaseName DatabaseSize(MB) Date
```
Server DBName Size Date
A DB 110 6/1/2023
A DB 113 7/1/2023
A DB 118 8/1/2023
A DB 130 9/1/2023
A DB 120 10/1/2023
A DB 140 11/1/2023
A DB...
```
--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 13, 2023 at 2:53 pm

#4345240
Reply To: Retrieving First Word, First + Second Word, First + Second + Third Word, First

Also NNNNIIIIIICCCCCCCEEEEEE!
If I get some time, I try to do some performance tests on the lot tonight. This is a part of why I love this community!
--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 13, 2023 at 2:30 pm

#4345236
Reply To: Calculated Time Periods Hierarchy

This is a predominately English speaking forum. Any chance of you posting the translation for all that instead of us having to run it through a translator?
--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 13, 2023 at 1:53 pm

#4345226
Reply To: JSON data with Pivoted

Tava wrote:
The JSON will always have the same values/pairs as that part is static.
That pairing is still not 100% as I'm taking suggestions provided by Phil/Steves to help improve 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 13, 2023 at 1:49 pm

#4345225

Viewing 15 posts - 886 through 900 (of 59,091 total)