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 a three-legged stool with a vermilion wedge under its short leg

Reduce IO Waits in SQL Server: Read the Waits First

January 8, 2019
Pinal Dave
SQL Performance
SQL DMV, SQL Performance, SQL Wait Stats

To reduce IO waits in SQL Server, first name the wait. This post explains the main IO wait types and measures two of them for a single session on a demo database. It then shows how to check file latency and which fix matches each wait.

Read More
Two ski tracks leaving the same spot on a snowy hill, one in easy turns, one ending in a scuffed hollow by a red ski pole

Finding the Plan That Changed: Query Store Plan History

January 7, 2019
Pinal Dave
SQL Performance
Execution Plan, Maintenance Plan, Query Store

Read Query Store plan history, compare duration by interval, find plan changes, and review a temporary force with an exit plan.

Read More
A lamplit wooden pier at dusk whose newly built far end extends past the last lamp into darkness.

The Ascending Key Problem: Estimates for Today’s New Rows

December 25, 2018
Pinal Dave
SQL Performance
Execution Plan, SQL Performance, SQL Server, SQL Statistics

Diagnose ascending key estimates with histogram boundaries, modification counts, and controlled comparisons before updating statistics.

Read More
A red wheelbarrow stopped across a garden path with three more wheelbarrows waiting behind it

Diagnosing Blocking Chains With sys.dm_exec_requests

December 12, 2018
Pinal Dave
SQL Performance
DBA, SQL DMV, SQL Lock, SQL Performance, SQL Wait Stats

Trace blocking chains from active requests to a candidate head session, inspect sleeping transactions, and verify the owner before action.

Read More
Many small loose bundles of wheat on a barn floor around one tall sheaf tied in red.

Columnstore Rowgroup Health: Finding Small and Open Rowgroups

November 22, 2018
Pinal Dave
SQL Performance
ColumnStore Index, SQL DMV, SQL Index, SQL Server

Inspect columnstore rowgroup health, understand small and deleted groups, and choose reorganize or rebuild from measured evidence.

Read More
A laden plum tree with a tiny bowl at its foot and a large red crate beside it.

Multi-Statement Table-Valued Functions and Interleaved Execution

November 21, 2018
Pinal Dave
SQL Performance
Execution Plan, SQL Function, SQL Performance, SQL Server 2017

See how interleaved execution corrects estimates for multi-statement table-valued functions and when an inline rewrite wins.

Read More
Two shoe racks with the same shoes, red pairs grouped on one and scattered on the other.

Multi-Column Index Key Order: Which Column Goes First

November 13, 2018
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Server

Test index key order with equality, range, and OR predicates, then use seek predicates and logical reads to choose the lead column.

Read More
Previous 1 … 45 46 47 48 49 50 51 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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