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 small chest with one vermilion drawer open beside a pile of wooden planks

Rebuild All Indexes on a Table in SQL Server: SSMS and T-SQL

April 7, 2020
Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Scripts, SQL Server Management Studio

To rebuild all indexes on a table, right-click the Indexes folder in SSMS and choose Rebuild All, or run ALTER INDEX ALL with REBUILD. This post checks fragmentation first, rebuilds a demo table and shows what the command does to a disabled index. It also compares REBUILD with REORGANIZE and the options that matter.

Read More
Gouache painting of an overflowing vermilion basket of linens beside a single copper washtub

Query for CPU Pressure: Sample the Scheduler Queue

April 2, 2020
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Monitoring, SQL Scripts

To sample the scheduler queue, read the runnable counts of every scheduler eight times, one second apart, and compare the result with a baseline. This post shows the queue on a quiet server and again while more busy sessions than schedulers run. It reads the spread, the streak and the average that tell pressure from noise.

Read More
Gouache painting of a half-woven basket with a bundle of reeds and one vermilion reed where the weaving stopped

Canceled Query Plan: Three Ways to Capture It in SQL Server

April 1, 2020
Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL DMV, SQL Server Management Studio

A canceled query plan can be captured with Live Query Statistics, with a live plan query while the statement runs, or from Query Store after the cancel. This post runs a long query, reads its plan while it runs, cancels it and then reads the aborted run from Query Store. It also explains which plan each method returns.

Read More
A wooden cable drum on a quay paying out rope, a red chalk mark on the rope showing how far it has moved.

Batch Requests and Compilations per Second From T-SQL

March 26, 2020
Pinal Dave
SQL Performance
Recompile, SQL Cache, SQL Counter, SQL DMV, SQL Server

Calculate compilations per second from cumulative SQL Server counters, compare batch rates, and investigate single-use plans with context.

Read More
Two hands across a table, one holding salt and one holding a red pepper shaker, each reaching for the other's.

Reading Deadlock Graphs From the system_health Session

March 24, 2020
Pinal Dave
SQL Performance
DBA, Deadlock, SQL Extended Events, SQL Lock

Read deadlock graphs from system_health, identify victims and resource owners, reproduce a two-session cycle, and choose a targeted fix.

Read More
A boat ramp ending in dry cracked mud with a red buoy at its foot, the lake shrunk far away

Stale Statistics: Detecting and Updating Them

March 20, 2020
Pinal Dave
SQL Performance
DBA, Execution Plan, SQL Performance, SQL Server Agent, SQL Statistics

Detect stale statistics with update properties, review modification thresholds, and schedule targeted refreshes with recorded outcomes.

Read More
Gouache painting of a row of cream bicycles in a shed and one distant vermilion bicycle alone on a hilltop path

Scheduler ID Values in dm_os_schedulers: What the Big Numbers Mean

March 13, 2020
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Server

Scheduler ID values in dm_os_schedulers run from 0 up to a few thousand, and then jump past one million. This post groups the rows into user, dedicated admin connection and hidden schedulers, and shows the filter that keeps CPU scripts honest. It also shows why filtering on the number alone is fragile.

Read More
Previous 1 … 26 27 28 29 30 31 32 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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