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 small proofing basket with a huge mass of dough spilling over its sides across a floured bakery bench.

Temp Table Statistics: Why a #Table Plan Goes Stale

July 12, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Performance, SQL Server, SQL Statistics, Temp Table

Inspect temp table statistics across procedure calls, compare estimates with loaded rows, and test targeted refresh and recompile fixes.

Read More
Gouache painting of a book lying open on a wooden desk, thin grey copy sheets beneath its blank pages and one vermilion sheet at the edge

Change Data Capture Cost: Log, Storage and Cleanup Measured

July 10, 2013
Pinal Dave
SQL Performance
SQL Log, SQL Performance, SQL Scripts

Change Data Capture cost shows up in places a quick setup never checks. On SQL Server 2025, the same update wrote three times the log with CDC on, the log waited for the capture, and the change table grew to almost four times the table. Here is every number and the script that produced it.

Read More
Cyclists riding in single file behind a leader in a vermilion jersey who breaks the wind for them.

OPTIMIZED_SP_EXECUTESQL in SQL Server 2025: Fewer Compile Storms

July 3, 2013
Pinal Dave
SQL Performance
Dynamic SQL, Recompile, SQL Cache, SQL Server

Test OPTIMIZED_SP_EXECUTESQL in SQL Server 2025, inspect compilation counters and cached plans, and compare a concurrent workload.

Read More
A small saucepan of stew on a stove, with a long dining table set for many guests visible through a doorway.

Estimated vs Actual Rows: The First Thing to Read in a Plan

June 26, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Performance, SQL Server, SQL Statistics

Read estimated vs actual rows in execution plans, find where the first gap appears, and investigate statistics, parameters, and predicates.

Read More
A small wooden model ship hull towed through a long indoor test tank, leaving a clean wake behind it.

Sample Databases for Practicing Performance Tuning

June 23, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Sample Database

Use sample databases for practicing performance tuning by checking data volume and skew, then enlarging the right tables carefully.

Read More
A shared workshop bench between two work areas, its surface covered in offcuts and marks from many jobs

What Is tempdb, and Why Everyone Shares It

June 13, 2013
Pinal Dave
SQL Performance
Best Practices, Database, SQL Performance, SQL Server

tempdb is one scratch database shared by every database on the instance. The three kinds of thing that land in it, why it is rebuilt at every restart, and the reason its file count keeps coming up.

Read More
A fresh photo print of a runner at the finish hanging to dry by a red clip in a darkroom

The Last Actual Execution Plan: LAST_QUERY_PLAN_STATS in Practice

June 3, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL DMV, SQL Server, SQL Server 2019

Capture the last actual execution plan with LAST_QUERY_PLAN_STATS, inspect runtime rows, and understand what cache retention cannot provide.

Read More
Previous 1 … 68 69 70 71 72 73 74 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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