Explain why a filtered index is ignored with parameters, inspect plan warnings, and compare literal filters, RECOMPILE, and coverage fixes.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed – The Server Principal Owns One or More Availability Group(s) and Cannot be Dropped
In this blog we would learn about fixing error Script level upgrade for database ‘master’ failed because of upgrade step ‘’msdb110_upgrade.sql’
SQL SERVER 2019 – Still Getting String or Binary Data Would be Truncated
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.
What is TempDB Spill in SQL Server? – Interview Question of the Week #259
When SQL Server uses TempDB when any query does not have enough memory to do its operation, it is called TempDB Spill. Let’s learn today.
SQL SERVER – Patch Failure – Disk Full: There is Not Enough Disk Space On the Volume
In this blog, I would share my findings of how I identified the cause of failure “Disk full: There is not enough disk space on the volume.”
SQL SERVER – Log Shipping Job Error: Failed to Connect to Server
As per them restore job was failing with errors. Let us learn how to solve Log Shipping Job Error: Failed to Connect to Server.
SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform this Operation – 2
Many disaster recovery solutions are available in SQL Server. Let’s learn how we can fix a specific log shipping error about the sysadmin fixed server role.
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.
Estimating vector Column Storage Before Loading Embeddings
Estimate vector column storage from dimensions, measure DATALENGTH and table allocation, and separate payload bytes from page overhead.
LPIM in Configuration Manager: Enable Lock Pages in Memory
You can set LPIM in Configuration Manager without editing the local security policy by hand. This post shows where the property sits, how to read it from PowerShell, and how to check the result with T-SQL after the restart. It also explains why a memory cap comes first.