Jeff Moden

Forum Replies Created

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

Reply To: How to use pagination for huge reports

Jeffrey Williams wrote:
SQL Guy 1 wrote:
It's just a select from 3 tables, and 2 of them are with left join. For aggregations, I would have done it on SQL Server side. Now I...
--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 30, 2023 at 12:29 am

#4354252
Reply To: How to use pagination for huge reports

Is your "report" going to return all 600 Thousand "records" or is it going do some form of aggregation?

--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 29, 2023 at 2:44 am

#4353810
Reply To: The AI Puzzle

Heh... AI being "confidently incorrect"... Imagine that. 😛

--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 29, 2023 at 2:36 am

#4353809
Reply To: Temp Tables Used within Procedure giving error in one 2019 sql server instance

To repeat the question that Phil asked but in different words....
You say something would "return error". Please copy and post that error.
--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 27, 2023 at 7:06 pm

#4353198
Reply To: How to establish a relationship in SQL Server
The following will do it without anything "fancy" that might not work in Oracle, which I've almost totally forgotten about.
```
   WITH
cteMinCustNbr AS
(--==== Calculate the minimum...
```
--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 26, 2023 at 4:43 am

#4352335
Reply To: A Thrill of Hope

skeleton567 wrote:
Why I was never popular with bosses:
Boss: Welcome to the shortest day of the year!
Me: Aren't all days 24 hours?
BWAAA-HAAA-HAAA!!! "IT DEPENDS".
https://en.wikipedia.org/wiki/Leap_second
--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 23, 2023 at 9:31 pm

#4351448
Reply To: JSON data with Pivoted

Tava wrote:
I actually just realised PIVOT isn't working when Multiple rows are present Putting a fake aggregation such as MAX isn't working as expected.
I'm stumped 🙁
Any ideas, to point me...
--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 11:57 pm

#4351036
Reply To: Are the posted questions getting worse?

Same to you and yours, Steve. And Merry Christmas to everyone. This is a well deserved 4 day weekend for me. Next weekend is, 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 22, 2023 at 11:50 pm

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

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