Problem

Apply XML compression to any table that has XML columns

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_apply_database_xml_compression.sql

Based on

How to compress XML data in SQL 2022? | SQL Server 2022 new features | Can SQL 2022 XML compression save disk cost with XML data?