Understand temp table caching in stored procedures, avoid cache blockers, inspect creation counters, and review retained statistics.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Relational, Document, Graph and Vector: Choosing the Right Data Model
Choosing the Right Data Model means matching the shape of your data to the questions you ask. This post stores one bookshop four ways in SQL Server 2025, with relational tables, JSON documents, graph tables and a vector column, and runs the question each one answers best. It ends with a rule for choosing.
Why SQL Server Has No Result Cache: Buffer Pool and Plan Cache
A second run is faster, but SQL Server did not remember your answer. A tiny demo shows what really gets reused: pages and plans.
SQL SERVER – How to Ignore Columnstore Index Usage in Query
A reader’s query ran slower after adding a nonclustered columnstore index. Here is how to ignore columnstore index usage for just that one query.
SQL SERVER – Fundamentals of Columnstore Index
Row store vs column store, explained simply. A Columnstore Index can make searches much faster, but it is not for every table. Learn where each one fits.
Searching Every Error Log for Slow I/O Warnings
The warning you need may be in an archived log. Here is a short loop that searches every retained error log and tells you which ones it could not read.
SQL Server Wait Stats: eBook to Download on Kindle and My Answer to Free PDF Requests
SQL Server Wait Stats was my first book experiment. Here is how I answered readers who asked for a free PDF, and what the Kindle offer looked like in 2011. Prices and offers are from that time.
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.