DBCC DBREINDEX still runs on SQL Server 2025, but it is deprecated, and ALTER INDEX does everything it did and more. This post rebuilds a fragmented demo table both ways, shows the options only ALTER INDEX has, and finds old uses of DBCC DBREINDEX in your own modules, Agent jobs and the deprecation counter.
Plan Properties Window: Where the Useful Numbers Hide
The execution plan picture only shows the shape. The properties window shows what really happened, and I walk through it on a tiny example.
Finding the Plan That Changed: Query Store Plan History
Read Query Store plan history, compare duration by interval, find plan changes, and review a temporary force with an exit plan.
Do Index Reorganization Update Statistics? – Interview Question of the Week #196
Question: Do Index Reorganization Update Statistics?
Answer: No. Index Reorganization does not update Statistics of your database.
Integration Services Evaluation Period Has Expired: Maintenance Plan Fails
The Integration Services evaluation period can expire while the Database Engine keeps running, and the maintenance plan that depends on it fails. In one client case backups stopped. These checks show how to find the failure, close the backup gap and identify the expiring component.
SQL SERVER – Maintenance Plan Error: Failed to Acquire Connection “Local Server Connection”.
None of the maintenance plans worked, though the jobs ran fine. The error was failed to acquire connection “Local server connection”. Here is why.
SQL SERVER – The SaveToSQLServer Method Has Encountered OLE DB Error Code 0x80004005
While saving maintenance plan on my lab server, I encountered below error in SQL Server Management Studio. Let us see how to solve the error related to OLE DB Error.