Here is the question asked in my yesterday’s Comprehensive Database Performance Health Check about rows sampled from sys.dm_db_stats_properties.
Let us learn about it in today’s blog post about the Statistics Modification Counter. The answers to this question is also very simple.
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.
During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.
Recently I got the opportunity to work on a very new feature of Persisting Sample Percentage for Statistics. Let us learn today.
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.