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 fitted guide locates one vessel while the surrounding tray remains preserved.

SQL SERVER – Delete Statement and Index Usage

September 17, 2020
Pinal Dave
SQL Performance
SQL Delete, SQL Index, SQL Scripts, SQL Server

An index can help a DELETE statement locate rows to remove. A customer asked whether indexes benefit modifications alongside SELECT queries.

Read More
Gouache painting of a weathervane on a barn roof with a vermilion arrowhead and wheat stalks in front

Statistics That Never Auto Update: Find the NORECOMPUTE Flag

August 4, 2020
Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Scripts, SQL Statistics

Statistics that never auto update usually carry a hidden NORECOMPUTE flag, set when an index was created. This post builds a demo table, shows the flagged statistic go stale while its neighbor updates itself, and lists every flagged statistic in a database. It also shows which maintenance commands clear the flag and which keep it.

Read More
Remove Bookmark Lookup

SQL SERVER – 7 Follow Up Answers to Remove Bookmark Lookup

July 28, 2020
Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Scripts, SQL Server

My video on bookmark lookups brought many questions. Here are 7 follow up answers to remove bookmark lookup doubts, starting with STATISTICS IO overhead.

Read More
Two neighboring work fixtures are inspected for balance beside a separate adjustment tool.

SQL SERVER – Boost SQL Server Priority and SSMS 18

July 18, 2020
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Management Studio

Boost SQL Server Priority appeared in the historical SSMS 18.5.1 interface. I showed where to inspect that engine setting.

Read More
Gouache painting of a row of identical sage rowboats at a lake dock with the last boat painted vermilion

Count TempDB Data Files: Five Ways to Check in SQL Server

July 16, 2020
Pinal Dave
SQL Performance
SQL Scripts, SQL Server Management Studio, SQL TempDB

You can count tempdb data files with the Properties window, three queries or the error log. This post shows all five checks with their results, explains what each one reads, and compares the count with the number of CPUs. It also covers the case where the Properties window won’t open.

Read More
Gouache painting of a crowd of spinning wind-up toys on a shelf with one vermilion top

Background Job Queue: List Active Jobs and Kill a Stats Job

July 15, 2020
Pinal Dave
SQL Performance
SQL DMV, SQL Scripts, SQL Statistics, System Object

The background job queue holds work that SQL Server runs outside your queries, such as asynchronous statistics updates. This post lists the active jobs, reads the queue counters, catches a real statistics job in a demo and kills it with KILL STATS JOB. It also corrects a common mix-up: the command takes the job ID, not the session ID.

Read More
A sewing machine with a half-finished seam, a hand pulling the fabric free with a loose thread still attached

Finding Queries the Application Cancelled With Attention Events

July 14, 2020
Pinal Dave
SQL Performance
Query Store, SQL Extended Events, SQL Monitoring, SQL Server

Capture attention events for canceled requests, read event-file XML, compare Query Store aborts, and inspect transaction cleanup.

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

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