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 three mountain paths from one post to the same hut, with a vermilion stone cairn on the middle path

Group by Query Hash: Find One Query With Many Plans

June 4, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL Performance, SQL Scripts

Group by query hash to add up every cached copy of one query. See why the top query hides across entries in SQL Server.

Read More
Gouache painting of two identical teapots on separate shelves, one on a vermilion saucer

Same Query Plan, Different Cache Entry in SQL Server

June 2, 2021
Pinal Dave
SQL Performance
Ad Hoc Query, Execution Plan, SQL Cache, SQL Scripts

The same query plan can sit in the cache many times when query text changes by a space, a letter case or a comment. See it, measure it and learn how to share one entry.

Read More
Gouache painting of a tray of mixed buttons beside four glass tubes of stacked buttons, the first tube filled with deep red buttons

Rowstore to Columnstore: Replace the Clustered Index

May 28, 2021
Pinal Dave
SQL Performance
ColumnStore Index, SQL Column, SQL Index, SQL Scripts

Rowstore to columnstore is a change of the clustered index, and one command works in only one case. This post builds two tables of 600,000 rows, shows the error from DROP_EXISTING on a primary key, and converts each table the working way. It compares the sizes before and after.

Read More
A caddie drawing the next club from a golf bag while the golfer is still walking toward the ball

Read-Ahead Reads in STATISTICS IO: What They Tell You

May 26, 2021
Pinal Dave
SQL Performance
Disk, SQL Performance, SQL Scripts, SQL Server

Interpret read-ahead reads in STATISTICS IO, compare isolated cold scans and seeks, and separate prefetch from storage-wait evidence.

Read More
Illustrated cover: 3 Memory Checks

SQL SERVER – 3 Queries to Detect Memory Issues

May 18, 2021
Pinal Dave
SQL Performance
SQL DMV, SQL Memory, SQL Scripts, SQL Server

One of the most popular conversations during Comprehensive Database Performance Health Check is about CPU and memory issues.

Read More
Gouache painting of a wooden loom with a cream weaving and a vermilion shuttle trailing red thread

OS Threads by Scheduler in SQL Server: Count Them per CPU

May 7, 2021
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Server

OS threads by scheduler shows how many Windows threads each SQL Server scheduler owns. This post joins the scheduler, worker and thread views and counts them per CPU. It compares the counts with the server totals and explains the hidden schedulers that a careless query counts as CPUs.

Read More
A grain sampling spear holding a small sample beside a full grain sack

rows_sampled: Checking How Much Data Your Statistics Saw

April 23, 2021
Pinal Dave
SQL Performance
Data Warehousing, Master Data Services, SQL Data Storage, SQL Statistics

A fresh statistic can still come from a small sample. Compare rows with rows_sampled and see how a sample misjudges a rare value.

Read More
Previous 1 … 14 15 16 17 18 19 20 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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