I recently built a process to create a new filtered index on a schedule to support a UI that only cares about the last 30 days.

I dug a little into one of the new RegEx functions in SQL Server 2025: REGEXP_SPLIT_TO_TABLE.