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 sash window latch selecting one pane within a larger window frame

statement_start_offset: Showing the Exact Statement Running Now

February 10, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

A stored procedure runs for forty minutes and you need the busy line. Here is how to pull it out of the batch text without the usual off-by-two mistakes.

Read More
Gouache painting of a long pegboard on a table with pliers, a saw, two vermilion-handled hammers, one set crosswise out of line

Performance Tuning Mistakes in SQL Server: 11 Habits to Fix

February 1, 2023
Pinal Dave
SQL Performance
Best Practices, SQL Backup and Restore, SQL Cursor, SQL Index, SQL Statistics

Performance tuning mistakes are habits, and each one has a check. Eleven sit in one table, and five are measured on a demo database: a missing index, stale statistics, a row by row loop, a giant delete and a type that cannot be indexed.

Read More
An electrotype mold kept separately beside an impression made from it

Updatable Ledger Tables: Proving No One Quietly Changed a Row

January 25, 2023
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Update a row in a ledger table and the old version stays. Then verify the history with a digest, and break the digest to see what failure looks like.

Read More
A milking pail with two portions of fresh milk added beside a larger retained total

Turning Per-Second Counters Into Real Rates From DMVs

December 13, 2022
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

That per-second counter on your dashboard is probably a running total. Here is how to turn it into a real rate with two samples.

Read More
Two boards overlapping at a woodworking bench dog while another pair just touches

Finding Schedule Clashes: Overlapping Sessions per Attendee

October 26, 2022
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

An attendee says two sessions run at the same time. Here is how to find every overlapping pair once, and why touching is not a clash.

Read More
A truffle shaver making thin slices beside a few thick slices

Query Store Interval Length: Choosing How Fine Your History Is

April 4, 2022
Pinal Dave
SQL Performance
Best Practices, Query Store, SQL Server

An hourly average can hide the slowdown users remember. Here is a small demo of Query Store interval length and how to choose it.

Read More
A lemon squeezer holding a small lemon half beside an oversized half that cannot fit its pressing cup

Will the Next Autogrowth Fit? Checking Growth Against Free Disk

February 9, 2022
Pinal Dave
SQL Tips and Tricks
Best Practices, Disk, SQL Server

The drive has free space, yet the file will not grow. Here is how to calculate the next autogrowth and test it against disk and MAXSIZE.

Read More
Previous 1 2 3 4 5 6 7 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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