Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,381 through 1,395 (of 59,099 total)

Reply To: Correcting fact table records that were changed by a user

I have to agree with Kimball. Never update a fact table. Only update the source of the data that the fact table was generated from and do the ETL thing...
--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)

June 26, 2023 at 7:44 pm

#4220048
Reply To: T-SQL the Problem with Scalar Functions breaking Parallelism

Johan Bijnens wrote:
Scalar functions are still a big NoNO ! ( Inlining doesn't work on all SVFs !! ) Write your SVFs as InlineTableValueFunctions and things will perform again
To that end,...
--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)

June 24, 2023 at 8:08 pm

#4218563
Reply To: Find spaces between First and Last Name in Microsoft SQL

Anjali66 wrote:
I only have select permission on this table. This is a third party vendor database and I cannot update/delete/insert or create procedure/functions in this database. I am getting 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)

June 24, 2023 at 3:38 am

#4218066
Reply To: Find spaces between First and Last Name in Microsoft SQL
```
--======================================================================================================
--      Create and populate the test table. This is not a part of the solution.
--======================================================================================================
--===== Create the test table.
   DROP...
```
--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)
June 23, 2023 at 4:33 pm

#4217744
Reply To: T-SQL the Problem with Scalar Functions breaking Parallelism

I write functions as an "ISF", a term that MS created a very long time ago in some now extinct documentation because they never created an "Inline Scalar Function". As...
--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)

June 23, 2023 at 3:50 pm

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

Michael L John wrote:
Jeff Moden wrote:
I'm thinking that you need to be more clear on the job description that you use to hire people... a LOT more clear. For more than just...
--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)

June 22, 2023 at 11:58 pm

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

Michael L John wrote:
Well, here is a new one.
While reviewing design standards with a set of contract developers we pointed out that any object needs to be qualified with the schema of...
--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)

June 22, 2023 at 7:20 pm

#4217022
Reply To: Calculating Prime Numbers With One Query

@ Jonathan,
Sorry... My previous post above was referring to the 10 million row run prior to your additional (@Start*@Start) optimization. I have to try your new optimization. I didn't look...
--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)

June 22, 2023 at 3:26 pm

#4216864
Reply To: Calculating Prime Numbers With One Query

p.s. I just tested the results of Jonathan's code against a 3rd party generator and it passed.
https://numbergenerator.org/numberlist/prime-numbers/1-1000000#!low=1&high=1000000&csv=nl&oddeven=&step=1&addfilters=prime_numbers-val-
Jonathan's code takes about 39 seconds for a max value of 10 million without...
--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)

June 22, 2023 at 12:13 am

#4216382
Reply To: Calculating Prime Numbers With One Query

Jonathan AC Roberts wrote:
Jeff Moden wrote:
That's pretty amazing. Now someone just needs to verify that it's actually producing the correct results using a brute force method.
It's basically a primes sieve, but instead...
--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)

June 21, 2023 at 11:42 pm

#4216380
Reply To: delete as head blocker

Remember that deletes affect all indexes (except maybe filtered indexes) and causes a check for every FK pointing at the table. There's some silly wide tables at one of 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)

June 21, 2023 at 2:08 pm

#4216093
Reply To: Calculating Prime Numbers With One Query

That's pretty amazing. Now someone just needs to verify that it's actually producing the correct results using a brute force method.
Also, I've not looked into it, is there a link...
--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)

June 21, 2023 at 2:02 pm

#4216092
Reply To: How to Avoid N+1 Queries: Comprehensive Guide and Python Code Examples

A far better way, IMHO, is to write a good SELECT in a stored procedure. 😉
What's the old saying? "Just because you can do it in Python, doesn't mean 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)

June 21, 2023 at 12:40 am

#4215662
Reply To: Calculating Prime Numbers With One Query

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
If they are implementing things like shift-left and shift-right maybe they should also implement unsigned integers.
It's coming... According to the way they handled things like GENERATE_SERIES(),...
--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)

June 20, 2023 at 7:33 pm

#4215493
Reply To: Calculating Prime Numbers With One Query

@steve-2 Collins,
Sorry... I tried your latest code on a max value of "just" 1 million. I stopped it at 2 hours and 8 minutes.
--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)

June 20, 2023 at 7:30 pm

#4215492

Viewing 15 posts - 1,381 through 1,395 (of 59,099 total)