Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 59,067 total)

Reply To: MDP/CTP values

If by MDP, you mean MAXDOP, I'd change it to 2. You've got a fairly heavy load to be giving folks half the total CPU power for their queries.
If by...
--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)

October 7, 2022 at 11:27 pm

#4096797
Reply To: OP identification

I'll second that. It would be mighty handy.
--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)

October 7, 2022 at 11:11 pm

#4096795
Reply To: Missing weekend data to Zero

I've not done a deep dive on it but isn't this the same request as the following link with different test data?
https://www.sqlservercentral.com/forums/topic/make-last-week-to-zero

--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)

October 7, 2022 at 11:03 pm

#4096794
Reply To: How to display original part and recommende part with each other but must recome

Here's the corrected math considering the 100,000 rows instead of the extra zero my too-quick keyboard added....
If the rest of the data follows the example of the data you provided,...
--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)

October 7, 2022 at 10:50 pm

#4096780
Reply To: How to display original part and recommende part with each other but must recome

Apologies... I used 1,000,000 for the source row count instead of just 100,000. I'll be back with corrected calculations.

--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)

October 7, 2022 at 10:07 pm

#4096777
Reply To: Insert data into multiple tables after each batch of 100000 rows

wrote:
I'm especially stayed aware of the article and I will get many benefits from it. Subsequently, thank you for sharing it.
This is a prelude to SPAM. It's becoming more...
--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)

October 7, 2022 at 8:40 pm

#4096760
Reply To: What's the CEIP?

If you had the answer of "Big Brother is watching", more people might have gotten a correct answer. 😀
--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)

October 7, 2022 at 7:26 pm

#4096737
Reply To: I must be loosing my mind. Odd data issue
Keep it simple...
```
--===== Find all items in Prod1 that are not in Prod2
 SELECT * FROM prod1.xxx.dbo.guest
 EXCEPT
 SELECT * FROM prod2.xxx.dbo.guest 
;
--===== Find all items in...
```
--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)
October 6, 2022 at 9:58 pm

#4096410
Reply To: How to insert data from same set of tables selecting different id from the same

You have 1 common StudentAccKey with 1 common StudentKey and 1 common StartDate.
And yet there are two StudentID's and six different StudentName's.
The code that you're using to get the data...
--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)

October 6, 2022 at 9:53 pm

#4096409
Reply To: How to run a query multiple times with different values in date

sailormonkey wrote:
I'm very new to the sql and am wondering what is the easiest way to run the same query multiple times with different dates (ideally is the last day...
--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)

October 5, 2022 at 5:41 pm

#4095919
Reply To: SQL Server Windows NT - 64 bit" in Task Manager: CPU high

I've found that the "sweet spot" for the 32 core machine at one of the companies I do work for is a MAXDOP of 4. Their biggest problem is 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)

October 5, 2022 at 5:29 pm

#4095916
Reply To: Azure SQL backup policy strategies and best practices?

Awesome link and explanation, Grant. Thank 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)

October 5, 2022 at 5:07 pm

#4095914
Reply To: Shrink database issue

Jeff Moden wrote:
Let's ask the question... how often do the "temp tables" appear? Let's also ask, why do you have "temp tables" of such a size to begin with?
The reason I'm...
--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)

October 5, 2022 at 4:50 pm

#4095896
Reply To: Add more columns to output

Bruin wrote:
Any help on this request... I tried to goggle but didn't see examples...
Thanks.
I think the problem is that people doubt your claim. Case in point...
https://www.google.com/search?q=Get+backup+status+for+multiple+sql+servers+using+powershell

--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)

October 4, 2022 at 8:22 pm

#4095518
Reply To: Shrink database issue

Let's ask the question... how often do the "temp tables" appear? Let's also ask, why do you have "temp tables" of such a size to begin with?
--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)

October 4, 2022 at 8:11 pm

#4095517

Viewing 15 posts - 2,626 through 2,640 (of 59,067 total)