Guy Glantser takes us through an edge case:
Many SQL Server DBAs rely on automated statistics maintenance solutions such as Ola Hallengren’s maintenance scripts. These scripts typically update statistics only when the modification counter exceeds a threshold.
But there is a corner case that can cause statistics to remain empty forever, and many DBAs are not aware of it.
Read on to see how you can end up with no statistics at all on a table.