Viewing 15 posts - 1,606 through 1,620 (of 7,608 total)
I have trouble even imagining the business or technical case where I'd ever design a table to have massive deletes all over the table at the...
April 30, 2021 at 2:15 pm
Yes... I'm well aware (and very thankful) that a given job can only be run once at a time. The concurrency I'm talking about is when you have...
April 30, 2021 at 2:05 pm
Yeah, I didn't go into deep details in the initial postings. Didn't seem necessary. I guess it was. I have trouble even imagining the business or technical case where I'd...
April 30, 2021 at 3:24 am
Fairly frequent random deletes lower the space used below the fill factor and thus can cause an issue with reorg.
First of all,...
April 30, 2021 at 3:08 am
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...
April 30, 2021 at 2:51 am
Personally, I'd remove SQL and re-add with the desired collation. Changing collations can be tricky, esp. on the master db.
April 30, 2021 at 1:45 am
We already keep 1 month of backup on drive and anything above that should transfer to shared backup network and that is...
April 30, 2021 at 1:43 am
IF you control the connection string, you can use a specific app name, and then a logon trigger can review the app name and decide if it wants to let...
April 29, 2021 at 10:02 pm
Have you reviewed page compression for the tables? If not, that's the first thing to look at. Unless the rows just keep having lots of updates through their entire history. Generally,...
April 29, 2021 at 9:59 pm
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
Viewing 15 posts - 1,606 through 1,620 (of 7,608 total)