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 full clothes airer, with the overflow of wet laundry draped over chairs and a radiator

Finding Queries That Spill With total_spills in Query Stats

October 25, 2022
Pinal Dave
SQL Performance
SQL DMV, SQL Memory, SQL Performance, SQL Server, SQL TempDB

Rank total_spills and recent counters, inspect plans, compare Query Store tempdb use, and investigate estimates before increasing grants.

Read More
A wooden butter stamp pressing a flower pattern into butter, a row of identical stamped pats behind it.

Prepared Statements and Plan Reuse From Application Code

July 25, 2022
Pinal Dave
SQL Performance
Ad Hoc Query, Execution Plan, SQL Cache, SQL Server

Inspect prepared statements, handle lifetimes, parameter types, cached Prepared plans, and the limits of optimize for ad hoc workloads.

Read More
A glassblower turning a half-formed glowing vase on a blowpipe, finished vases cooling on a shelf behind

Live Plans for Running Queries With sys.dm_exec_query_statistics_xml

June 23, 2022
Pinal Dave
SQL Performance
Execution Plan, SQL DMV, SQL Server, SQL Wait Stats

Read sys.dm_exec_query_statistics_xml for live plans, compare profile counts with estimates, and interpret partial progress carefully.

Read More
Gouache painting of a snail with a vermilion shell crawling along a long boardwalk

Long Running Queries in MySQL: Find Them in Two Ways

June 16, 2022
Pinal Dave
SQL Performance
Idera, MySQL, SQL Lock

Find long running queries in MySQL with two built-in methods: the slow query log and the Performance Schema digest table. See the settings, a ready query and how to choose between them.

Read More
Gouache painting of three hourglasses side by side, the first with grey sand and the other two with vermilion sand

Database File Latency: Read and Write Stalls per IO

June 7, 2022
Pinal Dave
SQL Performance
Disk, SQL DMV, SQL Performance, SQL Scripts

Database file latency is the stall time per read or write. This post divides the IO stall columns by the call counts for every file, explains the zero queued columns and says when a number is worth acting on.

Read More
A truffle shaver making thin slices beside a few thick slices

Query Store Interval Length: Choosing How Fine Your History Is

April 4, 2022
Pinal Dave
SQL Performance
Best Practices, Query Store, SQL Server

An hourly average can hide the slowdown users remember. Here is a small demo of Query Store interval length and how to choose it.

Read More
Detachable collars with a single chosen stud fitted to each collar

One Default Row per Customer With a Filtered Unique Index

February 1, 2022
Pinal Dave
SQL Performance
Clustered Index, ColumnStore Index, SQL Index

Two browser tabs, two default addresses. Here is how a filtered unique index keeps the rule in the database and how to switch defaults safely.

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

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