Thanks, that's what I'm hoping to do. Glad you like it.

If any of you would like to write up a little bit about your testing here, both with striping and other options, it might be good to have a few...

I've rarely done much work with them, so I find these tips and tricks interesting. There is a lot of value in using schemas for various separation items, like auditing,...

Henrik,

That's actually a great suggestions. I wasn't sure what naming to recommend, and hadn't spent much time on it, but I like the idea of mastersys as a way to...

How would you know what values to use in the new system? I don't see anything in the new one that would let you derive the 20 rejected for grapes.

https://www.sqlservercentral.com/articles/managing-transaction-logs

The used space in the log is always what's active. Inactive/truncated space is still there. You always want a pad in your file, as SQL Server manages this.

If you have code using these, it may have issues. Other than that, shouldn't be an issue.

Note: Microsoft recommends this: https://support.microsoft.com/en-sg/help/2868725/microsoft-security-advisory-update-for-disabling-rc4

Memory and standard edition might be one reason. Likely ignorance is the biggest cause. People don't think about them, or as Grant mentioned, heard about early limitations.

Make sure you have all the stripes. You need them all for a restore.

Does it work? What are the hassles of running it this way?

I'm a big fan of using things that work, not changing them without a good reason.

How do you know this is all whitespace? The log is reused and should be rewritten over time. There is a circular nature to this, with SQL Server writing through...

It should not be growing every day with log backups unless you have an increasing workload. I suspect you're missing something. Perhaps your log backup are not running as you...

That is weird. I assume you moved to numeric/decimal? Or something else?

Any other numbers that you found to be a problem? I could likely script this, but it's an interesting...

Is the growth linear, or is it all of a sudden one day?

Glad you know what you're doing, and certainly I've made...