This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Dec9

Row Mode Memory Grant Feedback: It Needs Level 150

Pinal Dave
SQL Performance
Execution Plan, SQL Memory, SQL Scripts
No Comments

Row mode memory grant feedback needs compatibility level 150 or higher, while batch mode needs only 140. A tested demo runs a row mode sort and a batch mode sort at levels 140, 150 and 170. The row sort keeps its grant of 11,888 KB at level 140 and drops to 1,536 KB at 150.

Continue Reading
Dec8

What is the Priority of Database Scoped Configurations? – Interview Question of the Week #254

Pinal Dave
SQL Interview Questions and Answers
SQL CPU, SQL Performance, SQL Server, SQL Server Configuration
2 Comments

Question: What is the Priority of Database Scoped Configurations over Global Configuration at Server Level?

Answer: This is a follow-up question.

Continue Reading
Dec7

Database Scoped Configuration Options in SQL Server

Pinal Dave
SQL Performance
SQL Scripts, SQL Server 2019, SQL Server Configuration
No Comments

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.

Continue Reading
Dec6

Missing tempdb Files: master_files vs database_files

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL TempDB
No Comments

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.

Continue Reading
Dec5

Why Query Cost Percentages in a Plan Mislead You

Pinal Dave
SQL Performance
Execution Plan, SQL Performance, SQL Server
No Comments

Test why query cost percentages are estimates by comparing two statements with STATISTICS IO, TIME, and query DMV counters.

Continue Reading
Dec4

Memory Grant Feedback Events: Capture Them in T-SQL

Pinal Dave
SQL Performance
SQL Extended Events, SQL Memory, SQL Scripts
No Comments

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.

Continue Reading
Dec3

Comparing a Good and a Bad Plan for One Query in Query Store

Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL Performance, SQL Server
1 Comment

Compare a good and a bad plan in Query Store using runtime history, SSMS Compare Showplan, estimates, joins, grants, and parallelism.

Continue Reading
Previous 1 … 136 137 138 139 140 141 142 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

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.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com