During the recent consulting engagement of SQL Server 2017/2019, my client asked me if I can help them enable the new feature of Row Goal.
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
During Comprehensive Database Performance Health Check I recently faced a brand new wait type WAIT_ON_SYNC_STATISTICS_REFRESH.
I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.
My client had hired me after reading my recent series on Parameter Sniffing. Today, we will discuss Database Scoped Configuration – Parameter Sniffing.