the database in sql server 2019 enabled ADR , when I update a column like size in 10GB , will the original mdf for that database grow 10GB due to version store ?
And also for rollback, the modified extent are overwrite from that in the version store , how long will it takes ? Or just some back end metadata pointing or switch over??
and for the insert statement , will it also create version store ??