What's the full, unedited output of
DBCC CheckDB WITH NO_INFOMSGS;

AGs do not use log backups, but you still need to take them (databases are in full recovery) and you do want to keep them around for DR.

Please don't post multiple threads for the same problem. Answered at https://www.sqlservercentral.com/Forums/1862776/Help-please-total-newbie-trying-to-learn-Trying-to-Change-the-first-character-in-a-field

I don't like looking at percentage waits, and imo, waits aggregated over more than an hour are useless, I can't tell what might have caused them.

Create a job...

SN, I'm not all that clued up on columnstore indexes (yet), what I read recently is that clustered columnstores are mostly for analytics systems (OLAP-style), while nonclustered columnstore indexes are...

The write speed is probably the least of the problems (unless you've got 10+ indexes). You've just duplicated that table, meaning it's taking up twice the space, twice the memory,...

A date, by definition, has no format because it's stored internally as numbers. Format is something specific to the string representation of a date.
In short, you can't. If you...

Yup, that's correct. What's the result of doing that?