Database scoped configuration options change how one database behaves, without touching the server. This post lists all 41 options on SQL Server 2025, finds the 7 ids that are missing, and changes and restores two settings in a demo database. It also answers the old question about configuration id 5.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Missing tempdb Files: master_files vs database_files
Missing tempdb files show up as a mismatch between sys.master_files and tempdb.sys.database_files. This post compares the two with a query, simulates the missing files on a copy of the catalog, and shows the error log message that gives the cause. The fix is to correct the path and restart.
Why Query Cost Percentages in a Plan Mislead You
Test why query cost percentages are estimates by comparing two statements with STATISTICS IO, TIME, and query DMV counters.
Memory Grant Feedback Events: Capture Them in T-SQL
Memory grant feedback events list every query whose memory grant keeps changing, and the moment SQL Server gives up on it. This post creates the Extended Events session in T-SQL, watches it live in SSMS and reads it with one query that names the procedure.
Comparing a Good and a Bad Plan for One Query in Query Store
Compare a good and a bad plan in Query Store using runtime history, SSMS Compare Showplan, estimates, joins, grants, and parallelism.
SQL SERVER – MemoryGrantInfo Property Explanation
I have been writing about the Memory Grant Feedback feature. Today we will discuss various properties of MemoryGrantInfo in this blog post.
MemoryGrantInfo – What are Different Status of IsMemoryGrantFeedbackAdjusted? – Interview Question of the Week #253
Question: What are Different Status of IsMemoryGrantFeedbackAdjusted (MemoryGrantInfo Property)? Today we will see a consolidated answer to this question.
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.