Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan while working on Comprehensive Database Performance Health Check.
SQL SERVER – Stream Aggregate and Hash Aggregate
Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.
SQL SERVER – OPTION(FAST N) Hint and Performance
I have a very interesting situation while working with SQL Server 2019, which I had not faced before about OPTION(FAST N).
SQL SERVER – Top Reasons for Slow Performance
Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.
SQL SERVER – Row Goal and Performance
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.
SQL SERVER – Performance and Recompiling Query – Summary
I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.
SQL SERVER – Parameter Sniffing and OPTION (RECOMPILE)
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.