Viewing 15 posts - 1,621 through 1,635 (of 7,614 total)
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...
April 29, 2021 at 12:38 am
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...
April 28, 2021 at 11:52 pm
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...
April 28, 2021 at 8:50 pm
I do need to add one caveat: if you DELETE rows throughout the table, you probably should avoid reorg. Once our data exists, we don't delete it, it never just...
April 28, 2021 at 7:13 pm
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 an unpartitioned...
April 28, 2021 at 6:23 pm
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...
April 28, 2021 at 6:12 pm
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. It helps if you've properly...
April 28, 2021 at 5:53 pm
and can't afford the time to do offline REBUILDs (which are nasty fast even in the full recovery model), then simply wait until you can.
Not necessarily. You seem...
April 28, 2021 at 5:42 pm
I don't think you should be repeatedly rebuilding 240GB of data. Much of that data must be historical, i.e. unchanging, so there's no need to use vast resources to keep...
April 28, 2021 at 5:37 pm
I've found one other use for REORG. When I've done massive deletes on a table, I've found that a REORG first is sometimes better than a REBUILD first. Follow the...
April 28, 2021 at 4:14 pm
Ooh, yeah, that is rough. Sorry, it must be a royal pain (no pun intended).
When I was a kid, my grandmother used to say, "Never get old." As I got...
April 28, 2021 at 4:10 pm
Perhaps. I was just going by his language that says the columns contain nulls. I don't think he ever used the words "all" or "only".
I was...
April 28, 2021 at 4:09 pm
You stated you're using stored procs. If so, try using a bigint SEQUENCE rather than a guid.
Also, it sounds like you insert multiple rows with the same guid/SEQUENCE. If so,...
April 28, 2021 at 4:02 pm
I think the OP does want to find only columns that are all NULL. Perhaps to remove the column?
April 27, 2021 at 8:46 pm
Viewing 15 posts - 1,621 through 1,635 (of 7,614 total)