Jeff Moden

Forum Replies Created

Viewing 15 posts - 841 through 855 (of 59,063 total)

Reply To: Upgrade to SQL2019 from 2012 and everything is slow - what to look for?

Update. We migrated from 2016 Enterprise Edition to 2022 Enterprise Edition. Virtually everything is run 30-40% slower. I also did some simple tests between 2017 and 2022 on the same...
--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 22, 2023 at 7:55 am

#4350665
Reply To: Which Thursday is the Holiday?
The following isn't dependent on DATEFIRST at all.
```
DECLARE @AnyYear INT = 2023;
 SELECT  ThanksGiving = v1.TG
        ,BlackFriday  =...
```
--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 9:04 pm

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

I agree... for the OP, I've not had to work with Linux nor containers.
Hopefully, this will be a nice "bump" to get someone that has to take a look at...
--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 8:53 pm

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

Mr. Brian Gale wrote:
I'm just saying that it is ALWAYS good to pick the right tool for the job.
Yep. Understood. All I'm saying is that too many people think that xp_CmdShell isn't...
--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 6:36 pm

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

Viewing 15 posts - 841 through 855 (of 59,063 total)