Why does SQL Server warn that Null value is eliminated by an aggregate or other SET operation? I show when it appears and how it can be suppressed.
SQL SERVER – Error: Fix for Error Msg 3906 – Failed to update database because the database is read-only
Getting Msg 3906, Failed to update database because the database is read-only? The message says it all. Here is how to make the database writable again.
SQL SERVER – How to fix the SQL Server Error 8657 or 8658?
Error 8657 and 8658 appear when a query or columnstore index build needs more memory than its Resource Governor workload group allows. Here is the fix.
SQL SERVER – FIX – Error 3201 – Cannot open backup device. Operating system error 3
BACKUP DATABASE failed with Error 3201, cannot open backup device, operating system error 3. The cause was a missing default folder. Here is the fix.
SQL SERVER – Error: Fix: Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file failed with the operating system error 2(The system cannot find the file specified.) – Part 2
A reader got error message 5133, Directory lookup for the file failed, while running a plain CREATE DATABASE with no path. Here is what caused it.
Insufficient System Memory: Msg 701 in a Resource Pool
Msg 701 reports insufficient system memory in a resource pool. This post reproduces it safely with a memory-optimized table on SQL Server 2025, shows the second message you get when the rows fill the pool, and lists the fixes that worked.
SQL Agent Alerts for Severity 17 to 25 and Errors 823, 824, 825
Configure Agent alerts for serious severities and errors 823, 824 and 825, connect an operator to Database Mail, and test response delays.