CPerIndexMetaQS::ErrorAbort in a stack dump points to index corruption in one of your databases. A reader had too many dumps, and the ERRORLOG and DBCC CHECKTABLE showed which index was bad. Here are the two repair options and why backups matter.
SQL SERVER – List Users with System Admin (sysadmin) Rights
I List Users with System Admin membership before agreeing on the permissions for a health check. This query inspects visible principals.
How to Kill Processes Idle for X Hours? – Interview Question of the Week #152
Interview question: how to kill processes idle for X hours in SQL Server? Here is a script that finds idle sessions and kills them.
Msg 41379: Restore Fails on Insufficient Memory in the Default Resource Pool
Msg 41379 stopped a restore because the default resource pool had insufficient memory for a database with In-Memory OLTP tables. We raised the memory available to the default pool to 90 percent, and the error disappeared.
SQL SERVER – Login Failed. The Login is From an Untrusted Domain and Cannot be Used with Windows Authentication – SPN Issue
Login failed, untrusted domain, error 18452, and a cluster that would not fail over. The cause was an SPN. How to read the SPN messages.
SQL SERVER – Always On Availability Group Failover Generating Dump. Error: 17066: SQL Server Assertion: HadrFstrVnnUtils.cpp:479
A client’s availability group failover across subnets got stuck in Resolving and generated dumps with Error 17066. Here is what we found and how we fixed it.
SQL SERVER – FIX: SQL Service Does Not Start After Promoting the Machine as Domain Controller
A SQL Server machine was promoted to a domain controller and the service stopped starting. Why it broke, the workaround we used, and the real fix.