What is SQL Server statistics auto-update threshold and its limitations?

Statistics auto-update triggers when a percentage of rows in a table changes.

SQL Server uses a threshold based on table size to decide when statistics are outdated. For small tables, a fixed percentage is used; for large tables, a square-root-based threshold applies. This can lead to stale stats in large rapidly changing tables, requiring manual or scheduled updates.