My clients enabled query store features to perform some troubleshooting which was a cause of unable to disable Query Store for Always On Database.
During the Comprehensive Database Performance Health Check, I had also helped the client build a query to list active and inactive VLF.
Recently I got a very unique situation where I had to Remove All Query Cached Plans Not Used In Certain Period. Let us learn about that today.
Question: What is the Replacement of DBCC DBREINDEX?
Answer: The answer to this question is very simple.
Here is the syntax:
It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients.