Viewing 15 posts - 1,996 through 2,010 (of 7,614 total)
Yes, sorry, as I stated in passing earlier, what I meant was that you "can't" in practice even if you can in theory because it takes so long...
January 5, 2021 at 12:30 am
However, if you "don't break the log chain", and something happens after the rebuilds, you WILL lose all data mods after the rebuilds, since you can't forward-recover using...
January 4, 2021 at 9:48 pm
Not a lot of details to go on, so I'll have to assume that the time is the same for the two rows that need brought together.
SELECT...
January 4, 2021 at 7:24 pm
p.s. Just in case there's a question about where I stand on this, I DO absolutely agree that taking a dif backup before and after Minimally logged rebuild should...
January 4, 2021 at 5:15 pm
That's not true, Scott. Not that you should but you can go back to the FULL Recovery Model from the BULK_LOGGED recovery model at any time without any kind...
January 4, 2021 at 4:59 pm
Again, though... they don't need to be full backups. They can be diffs to save some time and, possibly, reduce the size of backups.
If you intend to go back...
January 4, 2021 at 3:04 pm
Obscure objection. If there's corruption, you can't restore using your method. You can't restore to the middle of the rebuild process. Rebuild is atomic -- it works or...
January 4, 2021 at 1:03 am
We differ in opinion only on whether or not using the Bulk Logged or Simple Recovery Model would be a "Pyrrhic victory" victory or not. I'm simply not...
January 3, 2021 at 6:59 am
That's not true, Scott. The log can be applied. You just have to use the whole thing. You can't stop in the middle for a PIT restore. If something...
January 2, 2021 at 6:39 am
Agreed. I don't even see how to distinguish between a clock-in and a clock-out.
January 1, 2021 at 9:32 am
Say you have a 10GB table with 1 clus and 14 nonclus indexes, each with 1 column. You "tell" SQL to rebuild ALL indexes. Would SQL scan the...
December 31, 2020 at 10:26 pm
Excellent point about the CROSS JOIN. It's much more common than FULL. Probably want to add CROSS rather than FULL to the q. Or bring up FULL and/or CROSS in...
December 31, 2020 at 3:26 pm
No, the specific values are essentially the REPLACE equivalent of a binary search.
The initial code came from someone else. It performs really well overall, better than other methods, so I...
December 31, 2020 at 3:23 pm
Say you have a 10GB table with 1 clus and 14 nonclus indexes, each with 1 column. You "tell" SQL to rebuild ALL indexes. Would SQL scan the table 15...
December 31, 2020 at 5:03 am
Viewing 15 posts - 1,996 through 2,010 (of 7,614 total)