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
A paperback adventure book illustration in the old two colour style, a phone glowing on a bedside table at night.

SQL Server Blocking at 2 a.m.: You Are the On-Call DBA

November 2, 2026
Pinal Dave
SQL Performance
SQL Activity Monitor, SQL Error Messages, SQL Lock, SQL Scripts, Transaction Log

SQL Server blocking, told as a choose-your-own-path story. You are the on-call DBA. The phone has gone. The diagnosis and the kill were run in the lab on SQL Server 2025 and measured. The other branches are reasoned, and the text says which is which.

Read More
Old west poster illustration of eight slightly different outlaw sketches, faces hidden under hat brims, each with the same distinctive tear on the sleeve, and a pencil circle drawn around that tear.

Find the Query That Ran at 3 a.m.: A Wanted Poster

October 30, 2026
Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL Monitoring, SQL Performance, SQL Scripts

How to find the query that ran at 3 a.m. after the fact. It uses nothing but what SQL Server 2025 keeps on its own. I planted a culprit, gave it eight disguises and buried it in four hundred innocent lookups. Then I tracked it down with Query Store. This is the poster.

Read More
A newspaper obituary portrait in soft black and white of a server rack from the late 1990s, slightly out of focus, with a small black border.

The Nightly Index Rebuild Job, 1998 to 2026: An Obituary

October 27, 2026
Pinal Dave
SQL Performance
Maintenance Plan, SQL Index, SQL Performance, SQL Statistics, Transaction Log

The nightly index rebuild job has died after a long illness. It was born in 1998 to a hard disk that could not seek. It never believed the disk had been replaced. It is survived by page density, which did most of its work all along.

Read More
A colour plate in the style of a classic bird guide, eight small execution plan silhouettes arranged in two columns with numbers beside them.

Slow Queries: A Field Guide to Eight Species

October 23, 2026
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Scripts, SQL Wait Stats

Slow queries, identified the way a field guide identifies birds: by silhouette, habitat, call, and the species they’re confused with. All eight were raised in the lab on SQL Server 2025. The reads and the wait types are what each one produced.

Read More
Cartoon of a calm figure in a dark suit sitting for an interview, with a wall of hundreds of unlabelled filing drawers behind it.

The Query Optimizer Interview: Twenty Minutes, No Hints

October 21, 2026
Pinal Dave
SQL Performance
Best Practices, Developer, SQL Performance, SQL Server

The query optimizer sat down for twenty minutes and answered for itself. Why it ignored your index, why one procedure gets a plan built for the wrong caller, what it does when it cannot see your value, and the moment its own plan admits it stopped looking.

Read More
Profile card for PAGEIOLATCH_SH. Blamed for slow disks. Actually means the query is waiting for a page read to finish. Caused by scattered reads on a cold cache. What to do: look at the access pattern before you blame the storage.

Know Your Wait Types: Six Profiles, All Induced

October 16, 2026
Pinal Dave
SQL Performance
Best Practices, Developer, SQL Performance, SQL Server

I caused six wait types on purpose, one at a time, and measured each one for a single session. What each is blamed for, what it actually means, and the numbers it produced on SQL Server 2025. Wait types are the most misread figures in the product.

Read More
Recorded test: bigint used 848 leaf pages at 99 percent fullness; GUID used 1292 at 68.8 percent

When a GUID Clustered Primary Key Gets Expensive

October 14, 2026
Pinal Dave
SQL Performance
Clustered Index, SQL Datatype, SQL Index, SQL Performance

A GUID primary key can be useful. Learn when a GUID clustered primary key gets expensive, from page splits to index size, and when a bigint key can help.

Read More
1 2 3 4 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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