Content by perirocha (1)

perirocha introduces the generally available sp_get_table_health_metrics stored procedure for Microsoft Fabric Lakehouse tables, showing how SQL analytics endpoint users can diagnose physical table health (like small files, deleted rows, and checkpoints) in T-SQL and trigger OPTIMIZE only when it’s actually needed.