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 hose watering a vermilion pot beside three potted plants against a pale wall

sp_updatestats and Disabled Indexes: What Gets Updated

December 4, 2020
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Statistics

sp_updatestats and disabled indexes: the procedure updates statistics on disabled nonclustered indexes and skips a table whose clustered index is disabled. This post proves both, times the cost of disabled indexes against dropped ones on a million rows, and generates a targeted update that skips them.

Read More
Gouache painting of a short train with green carriages and a dark vermilion wagon at the front running along a track at dusk

JOIN Elimination in SQL Server: When a Table Drops Out

November 25, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Joins, SQL Scripts, SQL Statistics

JOIN elimination removes a joined table from the plan when the query does not need it. This post proves it with STATISTICS IO, then tests nine variations to show when it applies and when it does not, including a foreign key that has lost its trust.

Read More
Gouache painting of a row of watered garden beds with one bed covered by a vermilion tarp

sp_autostats: See and Undo Automatic Statistics Updates

November 17, 2020
Pinal Dave
SQL Performance
SQL Scripts, SQL Server Configuration, SQL Statistics

The sp_autostats procedure shows and changes the automatic statistics update setting of one table, one index or one statistic. This post turns the setting off for a table, flips it back for one index, undoes it, and shows that the database level setting and the statistics themselves are untouched.

Read More
An open folio remains available at the workbench beside a separate storage cabinet.

SQL SERVER – What is Logical Read?

November 12, 2020
Pinal Dave
SQL Performance
SQL Server, SQL Server Management Studio, SQL Statistics

A logical read requests a database page through the buffer cache. A customer asked about that measure after my STATISTICS IO video.

Read More
Bench, work-area and workpiece controls operate at three distinct scopes.

SQL SERVER – 3 Different Ways to Set MAXDOP

November 11, 2020
Pinal Dave
SQL Performance
MAXDOP, SQL CPU, SQL Scripts, SQL Server, SQL Server Configuration

There are 3 different MAXDOP scopes: instance, database and statement. Readers of my 16-versus-1 demonstration asked where to configure it.

Read More
A continuous thread passes through an external fixture and returns to its loom.

SQL SERVER – PREEMPTIVE Waits and Scheduler Context

November 9, 2020
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Wait Stats

Preemptive waits can measure work outside SQL Server cooperative scheduling. A customer asked about their increase during a health check.

Read More
Gouache painting of a trail post with three arrow pointers, one of them vermilion

Multiple OPTIMIZE FOR Hints in One Query: Value or UNKNOWN

November 6, 2020
Pinal Dave
SQL Performance
Execution Plan, Parameter Sniffing, Query Hint, SQL Scripts

Multiple OPTIMIZE FOR hints in one query are written as one list: each parameter gets its own value or UNKNOWN. This post compiles the same query six ways, reads the compile values and estimated rows from the plan cache, and shows which combinations SQL Server accepts.

Read More
Previous 1 … 19 20 21 22 23 24 25 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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