Let us learn about it in today’s blog post about the Statistics Modification Counter. The answers to this question is also very simple.
SQL SERVER – Best Practices for Dynamics NAV AX CRM
In the last 3 months, I have done nearly 11 consulting engagement for Dynamics NAV AX CRM while working on Comprehensive Database Performance Health Check.
SQL SERVER – Drop All Auto Created Statistics
During the recent consulting engagement, I ended up a very interesting situation where I had to drop all the auto created statistics.Â
SQL SERVER – Resolve WAIT_ON_SYNC_STATISTICS_REFRESH Wait Type
During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.
SQL SERVER – Persisting Sample Percentage for Statistics – PERSIST_SAMPLE_PERCENT
Recently I got the opportunity to work on a very new feature of Persisting Sample Percentage for Statistics. Let us learn today.
SQL SERVER Management Studio – Enable Statistics Time and IO for Every Query
I was asked a very interesting question about statistics TIME and IO for SQL Server Management Studio, let us discuss that in today’s blog post.
SQL SERVER – How to Drop All the Hypothetical Indexes of Database?
Earlier I wrote a blog post SQL SERVER – Say No To Database Engine Tuning Advisor and I got an email from my existing client where I frequently engage for Comprehensive Database Performance Health Check. They wanted me to help them remove all the negative impact of the Database Engine Tuning Advisor (DTA). I was able to help them achieve this by removing the Hypothetical Indexes they had added using the DTA.