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
Gouache painting of an empty wooden toolbox with three tools laid out in front of it: a flashlight, a magnifying glass with a vermilion handle and a stethoscope

Slow SQL Server? Three Queries to Run in the First Minute

May 26, 2014
Pinal Dave
SQL Performance
SQL in Sixty Seconds, SQL Performance, SQL Scripts

A slow SQL Server needs a quick look before any deep tuning. Three queries, using only what SQL Server ships, show what is running, which session sits at the head of a blocking chain and what the server is waiting on. Every result here comes from a slowdown staged on SQL Server 2025.

Read More
A carpenter's apron with a sagging pocket full of nails, and a large nail bin on a far shelf of the workshop.

Memory-Optimized Table Variables

May 25, 2014
Pinal Dave
SQL Performance
In-Memory OLTP, SQL Memory, SQL Server, SQL TempDB, SQL Variable

Memory-optimized table variables can avoid tempdb work, but they need a filegroup, indexed table type, memory budget, and workload tests.

Read More
A worn wooden staircase with a spotless new runner just laid down the middle of its treads

Index Usage Stats Reset: Reading Them Without Being Fooled

May 17, 2014
Pinal Dave
SQL Performance
Clustered Index, ColumnStore Index, SQL Index, SQL Wait Stats

Use index usage stats reset in SQL Server with practical examples, clear checks, and the limits you need before changing your database.

Read More
Steel boules scattered around a small red jack on a gravel square, some close, some far

Unstable Queries: Finding Wide Duration Swings in Query Store

May 3, 2014
Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL DMV, SQL Server

Find unstable queries with Query Store duration spread, weight averages, and separate plan changes from waits and parameter effects.

Read More
Three swimmers waiting in line on a jetty for a swimmer in a red cap to leave the only diving board

Signal Waits: Telling CPU Pressure From Slow Disks

April 29, 2014
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Performance, SQL Wait Stats

Measure signal waits over an interval, compare scheduler queues and file latency, and separate CPU scheduling pressure from storage delays.

Read More
Smooth wooden balls resting in separate shallow channels beside a crowded wooden bowl on a table.

When In-Memory OLTP Helps and When It Does Not

April 27, 2014
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Learn when In-Memory OLTP can reduce transaction contention, which limitations still matter, and what to measure before changing tables.

Read More
A small scoop rests beside a glass jar of mixed dried beans on a wooden table.

What the Cardinality Estimator Does and When It Is Wrong

April 26, 2014
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Understand how the cardinality estimator predicts rows, why estimates go wrong, and which statistics and plan checks help you investigate.

Read More
Previous 1 … 64 65 66 67 68 69 70 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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