The nightly index rebuild job has died after a long illness. It was born in 1998 to a hard disk that could not seek. It never believed the disk had been replaced. It is survived by page density, which did most of its work all along.
AI Row Count Estimates Come From Nothing
AI row count estimates arrive with tremendous confidence. Cardinal said four hundred. The query returned nine million.
Outdated Statistics in SQL Server: The Optimizer Is Planning for Last Year
Outdated statistics in SQL Server can slow a query even when its code has not changed. On SQL Server 2025 with the legacy estimator, a stale statistic sent one join to 120,043 logical reads, and a targeted update brought it down to 18,220. Auto update helps, but it waits for a threshold, it samples, and it knows nothing about the rows that arrived today.
Your Index Rebuild Maintenance Plan Is Rebuilding Indexes Nobody Uses
Your index rebuild maintenance plan takes four hours every Sunday, fills the log and delays the backup. It may be buying you far less than everybody assumes.
AI Execution Plan Analysis: I Gave It My Plan and Asked What Was Wrong
I handed AI a plan with no warnings and healthy numbers, yet it read five million rows to return seventeen. That is the real test of AI execution plan analysis.
Understanding the AUTO_DROP Option in SQL Server 2022
One such feature is the AUTO_DROP option for statistics. In this blog post, we’ll explore what the AUTO DROP option is, how it works.
SQL Server Maintenance Techniques: A Comprehensive Guide to Keeping Your Server Running Smoothly
This comprehensive guide explore into some essential maintenance techniques and best practices to ensure your SQL Server deployment.