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 fence painted halfway, a red-handled brush resting in the paint tin where the paint stops

Resumable Index Rebuilds: Pausing Maintenance Without Losing Progress

April 22, 2014
Pinal Dave
SQL Performance
DBA, Maintenance Plan, SQL Index, Transaction Log

Run a resumable index rebuild with ONLINE and MAX_DURATION, pause and resume it, inspect progress, and weigh edition and log costs.

Read More
A fishing float bobbing on a misty pond at dawn, ripples spreading, a rod propped on the bank beside a net.

Watching Live Data With the XEvent Profiler

April 18, 2014
Pinal Dave
SQL Performance
SQL Extended Events, SQL Profiler, SQL Server, SQL Server Management Studio

XEvent Profiler in SSMS offers live Standard and T-SQL event views; a focused Extended Events session serves repeat investigations.

Read More
Golfers seen from afar: one swinging on the tee, one waiting next, one searching the long grass for a ball

Running, Runnable, Suspended: The Life of a Query in sys.dm_exec_requests

April 17, 2014
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Server, SQL Wait Stats

Read running, runnable, and suspended SQL Server requests, inspect task states, and compare scheduler queues before diagnosing CPU pressure.

Read More
Diagram of performance statistic collection: Windows Perfmon every five minutes, loaded into a database, an SSRS report, emailed every morning to the administrators, with the Windows Server and SQL Server counter groups to collect

Performance Statistic Collection: Notes from the Field #018

March 6, 2014
Pinal Dave
SQL Performance
Notes from the Field, SQL Counter, SQL Monitoring, SQL Performance, SQL Server

Good tuning starts with good numbers. In Notes from the Field #018, David Klee explains performance statistic collection and how DBAs should gather server data.

Read More
Casey, Ace and Quinn face a busy night at the Clipboard Diner while a gray shadow falls across the floor, and Casey's clipboard unrolls into a list that runs right out the door. Casey says, "One wait a night. Slow is a list we can read."

Learning SQL Wait Stats: The Complete Series Guide

February 28, 2014
Pinal Dave
SQL Performance
SQL DMV, SQL Performance, SQL Wait Stats

Learning SQL Wait Stats is the fastest way I know to find out why a SQL Server is slow. This guide lists every post in my wait stats series, told as one story about an all-night diner, and answers the questions readers ask before they start.

Read More
Rows of closed paint tins, each lid dabbed with its color, a hand reaching for the tin with the red dab

Indexing JSON Properties With Computed Columns

February 18, 2014
Pinal Dave
SQL Performance
Computed Column, JSON, SQL Index, SQL Server

Improve indexing JSON properties with typed computed columns, matching paths, required SET options, and plan checks on your workload.

Read More
Four irons heating beside one small handkerchief on an ironing board, a hand unplugging the spare ones.

DOP Feedback: Letting SQL Server Lower Parallelism by Itself

January 27, 2014
Pinal Dave
SQL Performance
MAXDOP, Parallel, Query Store, SQL Performance, SQL Server 2022

Configure DOP feedback in SQL Server 2022, check Query Store evidence, and compare parallelism changes with your workload and MAXDOP limits.

Read More
Previous 1 … 65 66 67 68 69 70 71 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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