Let us learn about Memory Optimized in TempDB, which I had earlier discussed with my client Comprehensive Database Performance Health Check.
I would talk about enhancement in SQL Server 2019 Configuration Manager. Let us learn how to enable lock paged in memory (LPIM).
In this blog, we would see the current setting of instant file initialization and how to make the modification. Let us learn about it today.
After a lot of testing, I figured out that the newly introduced function is not always efficient. A newly-introduced function APPROX_COUNT_DISTINCT.
While working together we had a very interesting conversation about the Memory Grant Feedback and let me share that with you all here.
Let us see in this blog post the performance comparison between Batch Mode and Row Mode. The most asked question was about the Performance difference.