Let us learn about it in today’s blog post about the Statistics Modification Counter. The answers to this question is also very simple.
How to Get Details of All Files Associated with Database from MDF? – Interview Question of the Week #275
Question: How to Get Details of All files Associated with Database from MDF? Let us learn about the DBCC command DBCC command dbcc checkprimaryfile.
SQL SERVER – Unable to Disable Query Store for Always On Database
My clients enabled query store features to perform some troubleshooting which was a cause of unable to disable Query Store for Always On Database.
SQL SERVER – Query to List Active and Inactive VLF
During the Comprehensive Database Performance Health Check, I had also helped the client build a query to list active and inactive VLF.
SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period
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.
What is the Replacement of DBCC DBREINDEX? – Interview Question of the Week #263
Question: What is the Replacement of DBCC DBREINDEX?
Answer: The answer to this question is very simple.
Here is the syntax:
SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX
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.