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.
SQL SERVER 2019 – How to Enable Lock Paged in Memory LPIM?
I would talk about enhancement in SQL Server 2019 Configuration Manager. Let us learn how to enable lock paged in memory (LPIM).
SQL SERVER 2019 – How to Turn On or Enable Instant File Initialization?
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.
What is the Priority of Database Scoped Configurations? – Interview Question of the Week #254
Question: What is the Priority of Database Scoped Configurations over Global Configuration at Server Level?
Answer: This is a follow-up question.
SQL SERVER 2019 – Supports Compatibility Level from 2008 to 2019
One thing impressed me about the latest version of SQL Server 2019 is its support to Compatibility Level from 2008 to 2019.
Why Query Store Actual Operation Mode is Not Same as Requested? – Interview Question of the Week #248
Question: Why Query Store Actual Operation Mode is Not Same as Requested? Query Regression (poor performing queries, once working great)
SQL SERVER – Turning Off Priority Boost Server Configuration Option on SSMS 18 Onwards
While working together we figured out one of the many issues was the priority boost server configuration. Let us talk about it a bit more in detail.