In this blog, I would share the steps to identify and fix error – The account running SQL Server Setup does not have administrator rights on the computer.
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.