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
Two street lamps on a cobbled square at night whose pools of light overlap in one brighter patch

Splitting OR Conditions Into UNION ALL for Index Seeks

December 27, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Server, SQL Union clause

Test splitting OR conditions into disjoint UNION ALL branches, preserve NULL behavior and row identity, and compare actual index access.

Read More
A hearth ash rake beside settled ashes from an earlier fire

tempdb-Heavy Queries: Finding Them in Query Store

December 8, 2021
Pinal Dave
SQL Performance
Query Store, SQL Server, SQL TempDB

The tempdb spike is over before you log in. Query Store remembers who caused it, and here is how to ask.

Read More
A sieve holds a few kernels above a trough full of sifted grain, with a larger mound behind

TOP N Sort: Why a Small TOP Still Reads the Whole Table

November 3, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Order By, SQL Server, SQL Top

Explain TOP N Sort, compare an indexed ordered access path, and align filter and sort keys before adding indexes for frequent requests.

Read More
Matching workpieces are compared around a new fitted guide and its maintenance tools.

SQL SERVER – Measure Index Performance

October 27, 2021
Pinal Dave
SQL Performance
Clustered Index, SQL Index, SQL Server, SQL Statistics

I measure index performance against the same workload before and after a change. A customer wanted to assess a new index.

Read More
A broad fitting catalog remains distinct from a selected work tray and retained records.

SQL SERVER – List of Trace Events

October 13, 2021
Pinal Dave
SQL Performance
SQL Extended Events, SQL Scripts, SQL Server, SQL Trace

sys.trace_events lists available SQL trace events rather than only default-trace collection. Readers asked after my creation-date article.

Read More
Illustrated cover: Partitioning Is Not Speed

SQL SERVER – Table Partitioning for Slow Performance

October 4, 2021
Pinal Dave
SQL Performance
SQL Server, Table Partitioning

Something just conversation which I keep on doing again for ages. One of the conversations which never gets old is Table Partitioning for Slow Performance.

Read More
Gouache painting of a turning waterwheel at a mill while a vermilion wheelbarrow of grain climbs a long ramp

CPU Scheduler Waiting on Disk: Read Pending Disk IO

September 21, 2021
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Server

A CPU scheduler waiting on disk shows pending disk IO on its scheduler. This post reads sys.dm_os_schedulers once and in a short sampling loop, then confirms the result with file latency.

Read More
Previous 1 … 10 11 12 13 14 15 16 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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