Jeff Moden

Forum Replies Created

Viewing 15 posts - 856 through 870 (of 59,071 total)

Reply To: Table Migration script copying over more rows than intended

GBeezy wrote:
Thank you all for the help! Phil's suggestion worked for me, I was trying to avoid it as there is no leading index on the date columns.
I as well...
--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, 2023 at 3:39 pm

#4348332
Reply To: Help on Aggregation

I can't help with SSRS but I'm still trying to figure out why anyone would want to remove facts that matter from an aggregate. This appears to be a "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 17, 2023 at 9:27 pm

#4347846
Reply To: Get text from table and join with BIT column on table 2

As a bit of a sidebar, this is why people need to make sure they have normalized data in their tables instead of "convenient" data. Table 2 needs to 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 16, 2023 at 1:09 am

#4346920
Reply To: Cant extract values from JSON Array

Heh... lordy. OK... Two more reasons why I'm glad I don't have to deal with Azure. "Trapped Short Rows" can relatively large decreases in performance. Now I see why you...
--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 15, 2023 at 3:52 am

#4346286
Reply To: Cant extract values from JSON Array

Steve Collins wrote:
ZZartin wrote:
Well the flip side of that question is, if you're passing the information on to a system that wants to read JSON do you store the sqlified...
--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:32 pm

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

Viewing 15 posts - 856 through 870 (of 59,071 total)