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 row of wooden trays of sawdust on a workbench with the overflowing one in vermilion

TempDB Performance: Five Settings to Check in SQL Server

June 19, 2019
Pinal Dave
SQL Performance
Best Practices, SQL Data Storage, SQL Scripts, SQL Server, SQL TempDB

TempDB performance depends on five settings that you can read in a few minutes: how big it is, how many data files it has, whether they match, how it grows and where it lives. Three read-only queries check each one. The post also explains what to do with the answers.

Read More
Gouache painting of a vermilion cart rolling crates up a wide ramp onto a boat while a narrow plank stands unused

CHECKPOINT Duration: Can You Speed Up a Manual CHECKPOINT?

June 18, 2019
Pinal Dave
SQL Performance
Best Practices, SQL Memory, SQL Scripts, SQL Server

The CHECKPOINT duration argument sets a target time in seconds. This post times a manual checkpoint on a database with 130 MB of dirty pages, and shows that a long duration slows it badly while a short one does not make it faster. It also shows that a backup flushes dirty pages by itself.

Read More
A small desk organizer holds neatly arranged pencils beside a plain adjustable reading lamp.

Ten SSMS Settings Worth Changing on Day One

April 29, 2019
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Review ten SSMS settings for safer connections, clearer results, useful plans, and recoverable query text before starting your everyday work.

Read More
Three plain hourglasses with different sand levels stand beside a closed notebook on a wooden desk.

The Handful of Counters That Actually Matter

April 24, 2019
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Make SQL Server monitoring useful by relating waits, batch activity, memory indicators, and file latency to the same workload and observation window.

Read More
Juggling clubs sharing the air while completed clubs rest on a padded mat

Peak Concurrency: The Busiest Moment From Start and End Times

April 23, 2019
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Counting sessions per day tells you nothing about overlap. Here is a small event-sweep query that finds the busiest moment, with the tie trap explained.

Read More
An open hand fan with many ribs connected to one shared pivot

Capturing Successful Logins With an Extended Events Session

April 12, 2019
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Extended Events, SQL Server

A login event is a connection, not a user action. A small session shows how one query can leave three of them behind.

Read More
A spline roller seating one continuous cord with a remaining coil, loop, and tail

Countdowns in T-SQL: Days, Hours and Minutes Until an Event

April 10, 2019
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

A countdown that says 1 day for a one-second gap is counting boundaries, not time. Here is how to build one that tells the truth.

Read More
Previous 1 … 4 5 6 7 8 9 10 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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