Could not allocate space for an object because the ‘PRIMARY’ filegroup is full and The File Size, Max Size Cannot be Greater Than 2147483647
SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?
I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is used by SQL Server?
SQL SERVER – PolyBase Error Msg 46530 – External Data Sources Are Not Supported With Type GENERIC
In this blog, I would share my findings of error Msg 46530 – External data sources are not supported with type GENERIC. Let us read more…
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 2019 – New Values in Sys.Configurations
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 Pages 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.