If you have read release notes of SQL Server 2019, Microsoft has finally made an enhancement to error 8152 – String or binary data would be truncated.
I have written quite a few blogs about this release. In this blog, we would see the new options available in sys.configurations catalog view.
I would talk about enhancement in SQL Server 2019 Configuration Manager. Let us learn how to enable lock paged in memory (LPIM).
Let us learn, ISNUMERIC Function and Interesting Result. An interesting observation from my client of the Comprehensive Database Performance Health Check.
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.