Calculate weighted averages with matching numerator and denominator populations, decimal arithmetic, NULL rules, and calendar windows.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Setup Error 0x86D80018: No More Endpoints Available From the Endpoint Mapper
Setup error 0x86D80018 stopped a SQL Server 2016 to 2017 cluster upgrade when the client patched the second node. The Next Step in the setup summary named an uninstall command. Running it, then rebooting both nodes, let setup finish.
Batch Requests and Compilations per Second From T-SQL
Calculate compilations per second from cumulative SQL Server counters, compare batch rates, and investigate single-use plans with context.
Msg 3254: The Volume on Device Is Empty During RESTORE
Msg 3254 says the volume on a device is empty, followed by Msg 3013, RESTORE DATABASE is terminating abnormally. A client’s DBA hit it during a restore. In my lab, a text file passed off as a backup gave the same error, and the file size told the story.
Reading Deadlock Graphs From the system_health Session
Read deadlock graphs from system_health, identify victims and resource owners, reproduce a two-session cycle, and choose a targeted fix.
Error 9002: Transaction Log Full Due to REPLICATION
A transaction log full due to REPLICATION put error 9002 in a client’s ERRORLOG. The database showed no replication at all. The cause was a leftover publication with no subscriber, and here is how we cleared it and shrank the log.
What is the Difference Between sql_handle and plan_handle?- Interview Question of the Week #269
Question: What is the Difference Between sql_handle and plan_handle?
Answer: I was recently asked this question. Let us see the answer today.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.