Jeff Moden

Forum Replies Created

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

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

DotNetCoder wrote:
I agree with you 10000%, however, the DB was created before I joined the project, so I'm kind of stuck with some of the table structures at this time.
TruDat!
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 18, 2023 at 4:38 pm

#4348373
Reply To: How to write to a file from SQL Server running on Docker Container on Linux

Mr. Brian Gale wrote:
xp_cmdshell is easy to abuse so I use it sparingly.
I also find that any time I am looking to use xp_cmdshell, it is likely because I am 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)

December 18, 2023 at 4:30 pm

#4348346
Reply To: Weird formatting issue

Mr. Brian Gale wrote:
Just saw this one pop up, not sure if it is a "known" bug or not, but thought I'd report it as I didn't see it in this section.
If...
--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 4:23 pm

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

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