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 an old dusty wooden plane pushed aside next to a gleaming vermilion plane

DBCC DBREINDEX: Replace It With ALTER INDEX in SQL Server

August 26, 2019
Pinal Dave
SQL Performance
Maintenance Plan, SQL Deprecated Feature, SQL Index, SQL Scripts

DBCC DBREINDEX still runs on SQL Server 2025, but it is deprecated, and ALTER INDEX does everything it did and more. This post rebuilds a fragmented demo table both ways, shows the options only ALTER INDEX has, and finds old uses of DBCC DBREINDEX in your own modules, Agent jobs and the deprecation counter.

Read More
Gouache painting of a balance scale tipping toward a vermilion basket of apples against a few pears

Read Heavy Workload or Write Heavy: Measure It in SQL Server

August 24, 2019
Pinal Dave
SQL Performance
SQL Counter, SQL DMV, SQL Scripts, SQL Server

To tell a read heavy workload from a write heavy one, compare what the server reads with what it changes, and measure it over a window. This post counts reads and writes per table, reads the buffer and log counters with two snapshots, and explains what each lens misses.

Read More
Gouache painting of three windows of different shapes in a courtyard wall all showing the same vermilion flowerpot

Actual Execution Plan in SQL Server: Graphical, Text and XML

August 22, 2019
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server, SQL Server Management Studio

An actual execution plan shows how SQL Server really ran a query, with the true row counts beside the estimates. This post gets the plan three ways, as a graphical plan, as text with SET STATISTICS PROFILE and as XML, and uses a demo table to show how the estimate and the actual number can disagree.

Read More
Gouache painting of a row of watering cans on a bench with one leaking vermilion can

IO Stalls by Database File: Find the File to Move

August 21, 2019
Pinal Dave
SQL Performance
Disk, SQL DMV, SQL Scripts, System Object

IO stalls measure how long SQL Server waited for the disk, file by file. This post ranks the files of a demo database by stall time, measures a workload with two snapshots, lists the busiest files of a whole instance, and explains how to pick the one file that belongs on the new drive.

Read More
Gouache painting of a shelf with one vermilion bucket and four more stacked aside

Remove Extra tempdb Files in SQL Server Safely

August 19, 2019
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server DBCC, SQL TempDB

To remove extra tempdb files, empty each file first with DBCC SHRINKFILE and then remove it with ALTER DATABASE. This post checks the file count and the allocation waits before you start, rehearses both steps on a demo database, shows the tempdb statements with their undo, and explains why emptying can fail.

Read More
Gouache painting of wheelbarrows of apples waiting in line at one apple press with the first barrow in vermilion

Runnable Sessions in SQL Server: What to Check Next

August 16, 2019
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Server

Runnable sessions are sessions that have everything they need except a free CPU. This post counts requests by status, checks that SQL Server can see every processor, reads the settings that cap CPU use, and lists the statements waiting in the queue, so a long queue next to a half idle CPU stops being a puzzle.

Read More
Gouache painting of a small sailboat with a loosely furled vermilion sail while trees bend in the wind behind it

Windows Power Plan for SQL Server: Use High Performance

August 13, 2019
Pinal Dave
SQL Performance
Hardware, SQL CPU, SQL Server Configuration, Windows

The Windows power plan decides how fast the processors run, and an energy saving plan can slow SQL Server without raising any error. This post shows how to check the active plan, how to switch it and undo the change, and how to time the difference with a repeatable T-SQL loop.

Read More
Previous 1 … 37 38 39 40 41 42 43 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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