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
Apr5

USE HINT: Switching Off One Optimizer Rule Without Trace Flags

Pinal Dave
SQL Performance
Query Hint, Query Store, SQL Server, TraceFlags
No Comments

Apply USE HINT to one query, inspect supported names, compare optimizer behavior, and manage Query Store hints with a clear removal plan.

Continue Reading
Apr2

When Did SQL Server Last Restart? Four Ways to Check

Pinal Dave
SQL Tips and Tricks
DBA, SQL DMV, SQL Log, SQL Server, SQL TempDB
2 Comments

Find SQL Server’s last restart using startup metadata, tempdb, logs, and sessions, then interpret reset counters correctly.

Continue Reading
Apr1

Top 1 and Index Scan: A Scan That Stops After One Row

Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Scripts, SQL Top
No Comments

Top 1 and index scan can sit in the same plan, and the scan still reads only a few pages. This post runs six queries on a table of 100,000 rows and reads their logical reads. It shows why TOP 1 reads three pages in one case and every page in another.

Continue Reading
Mar31

Cached Data Per Object in Memory: Read the Buffer Pool

Pinal Dave
SQL Performance
SQL DMV, SQL Memory, SQL Scripts, SQL Server
2 Comments

Cached data per object tells you which tables and indexes fill the buffer pool. This post builds two demo tables, empties their cache and reads part of the data. A query then lists the pages, megabytes and share of each index in memory. It also explains why the view is costly on a big server.

Continue Reading
Mar30

Disable Adaptive Join for One Query or a Whole Database

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

To disable adaptive join for one query, add a USE HINT to it. This post also shows a Query Store hint for code you cannot edit and the database setting that switches the feature off for everything. Each switch is tested on a small demo database and checked in the plan.

Continue Reading
Mar29

Job Steps That Fail While the Agent Job Reports Success

Pinal Dave
SQL Tips and Tricks
SQL Reports, SQL Server, SQL Server Agent
No Comments

A green job history does not mean every step worked. Decode the failure routing and pair failed steps with their outcomes.

Continue Reading
Mar26

Enable Adaptive Join in SQL Server: Why It Does Not Appear

Pinal Dave
SQL Performance
Execution Plan, SQL Joins, SQL Scripts, SQL Server
1 Comment

To enable adaptive join in SQL Server, the compatibility level, the database setting and the query must all agree. This post builds a demo database and probes the plan under each condition. It also corrects older advice whose statements switch the feature off.

Continue Reading
Previous 1 … 73 74 75 76 77 78 79 … 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