Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,341 through 5,355 (of 59,098 total)

Reply To: Different backup folders (Full, Diff and Log) using ola script

Heh... lordy... never mind. Nothing has changed in the last decade. Jeffrey Yao has an article on the subject. These aren't what I call "easy" methods and some of them...
--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)

April 30, 2021 at 2:47 am

#3877643
Reply To: Different backup folders (Full, Diff and Log) using ola script

ScottPletcher wrote:
You have 512 bytes (or less, depending) you can use to rather easily pass stuff from step to step. If that's not enough, you can use chunks of 7500...
--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)

April 30, 2021 at 2:37 am

#3877642
Reply To: Different backup folders (Full, Diff and Log) using ola script

Jeffrey Williams wrote:
Jeff Moden wrote:
EasyBoy wrote:
We already keep 1 month of backup on drive and anything above that should transfer to shared backup network and that is the requirement...
--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)

April 30, 2021 at 12:28 am

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

It's really stupid... they all look like good ol' fashioned Arial with slightly different spacing. Heh... you can change the package but it's still the same ol' Ritz. No wonder...
--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)

April 29, 2021 at 3:25 pm

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

Good lord... the things MS spends money on. This seems a bit ridiculous to me especially when there's still so much in the product that needs to be fixed.
https://www.theverge.com/2021/4/28/22407297/microsoft-office-new-default-font-2022
--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)

April 29, 2021 at 11:46 am

#3877332
Reply To: Index rebuild

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
Fairly frequent random deletes lower the space used below the fill factor and thus can cause an issue with reorg.
First of all, those are...
--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)

April 29, 2021 at 12:52 am

#3877168
Reply To: Index rebuild

ScottPletcher wrote:
Fairly frequent random deletes lower the space used below the fill factor and thus can cause an issue with reorg.
First of all, those are NOT random deletes. They're...
--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)

April 29, 2021 at 12:19 am

#3877161
Reply To: Index rebuild

Sergiy wrote:
How massive are your DELETEs?
Probably it would be easier to copy the remaining part of data to a new table (exact copy of the old one) and then...
--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)

April 29, 2021 at 12:07 am

#3877158
Reply To: Index rebuild

ScottPletcher wrote:
Presumably that 147GB CI had (nearly) every page out of logical order or (nearly) every page was below the fillfactor. Hmm, veryh odd, interesting.
Again, I can't imagine needing...
--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)

April 28, 2021 at 11:44 pm

#3877149
Reply To: Partitioned Heap Table

qbrt wrote:
Hope that answers your question.
It does, indeed. Thanks for the feedback.
As a bit of a sidebar and especially since the partitioning is done on a temporal column, consider a...
--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)

April 28, 2021 at 7:51 pm

#3877048
Reply To: Partitioned Heap Table

I'm just curious... Do you ever do SELECTs from this partitioned HEAP? Do you ever UPDATE any of the rows in the HEAP? What's the HEAP actually used for? It...
--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)

April 28, 2021 at 6:15 pm

#3877011
Reply To: Index rebuild

ScottPletcher wrote:
I still have to disagree on REORG if: (1) you can't use online rebuilds AND (2) the table has some serious fragmentation you need to address AND (3)...
--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)

April 28, 2021 at 6:11 pm

#3877009
Reply To: Swimming Servers

ratbak wrote:
Based on To cool datacenter servers, Microsoft turns to boiling liquid => 3M Immersion cooling for data centers, it sounds like it's one of these: Fluorinert™...
--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)

April 28, 2021 at 4:56 pm

#3876971
Reply To: Index rebuild

Ah... gotta be careful even with those conditions. If you can tolerate the extreme log file usage on such things (the 147/227GB table I cited above was fragmented only my...
--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)

April 28, 2021 at 4:48 pm

#3876969
Reply To: Index rebuild

premkuttan wrote:
It has both reorg and rebuild. My index job runs through a different tool so it keeps to retry even if there is a interruption in SQL connection
REORGANIZE...
--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)

April 28, 2021 at 3:53 pm

#3876948

Viewing 15 posts - 5,341 through 5,355 (of 59,098 total)