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.
SQL SERVER – Unable to Run Maintenance Plan. Error: Integration Services Evaluation Period has Expired
A client’s maintenance plan failed with Integration Services evaluation period has expired in the job history. Here is why it happened and the fix.
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.
SQL SERVER – Execution Failed. See the Maintenance Plan and SQL Server Agent Job History Logs for Details
My client ran a new Maintenance plan for full and log backups and it failed at once. The reason was two subplans in one plan. Here is how to run them.