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
Sep14

FORMAT vs CONVERT: The CPU Cost of Pretty Dates

Pinal Dave
SQL Tips and Tricks
SQL CPU, SQL DateTime, SQL Performance
No Comments

FORMAT makes dates look nice, but it costs CPU on every row. Here is the gap, and where it hurts most.

Continue Reading
Sep13

SQL SERVER – Flushing Transaction Log to Disk for Current Database

Pinal Dave
SQL Tips and Tricks
No Comments

A reader using delayed durability asked how to be sure every log record reaches the disk. This is how flushing transaction log to disk works for a database.

Continue Reading
Sep12

Choosing a Technical Conference Worth Attending

Pinal Dave
SQL Tips and Tricks
Conferences, Professional Development, SQL Server, SQL Training
No Comments

Choose a technical conference by matching sessions and audience to your skill goals, then counting the full cost before you book.

Continue Reading
Sep11

Hey DBA – Go Make a Proactive Investment Today! – Notes from the Field #045

Pinal Dave
SQL Tips and Tricks
Notes from the Field
1 Comment

Mike Walsh explains why every DBA should be proactive, then gives all of us one challenge to complete: make a proactive investment today.

Continue Reading
Sep10

Delayed Transaction Durability Explained: SQL in Sixty Seconds #074

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Performance, SQL Transactions, Transaction Log
No Comments

Delayed transaction durability lets a commit return before its log record reaches the disk. This post explains the idea and the three settings, then measures 10,000 small transactions on SQL Server 2025 and shows the one risk with a log write count. It ends with a simple rule for using it safely.

Continue Reading
Sep9

SQL SERVER – Delayed Durability Database Level and Transaction Level

Pinal Dave
SQL Tips and Tricks
2 Comments

A reader asked how database level and transaction level durability settings interact when they conflict. I simplify the MSDN grid for delayed durability.

Continue Reading
Sep8

Example of Delayed Durability: How Much Faster Are Commits?

Pinal Dave
SQL Performance
SQL Performance, SQL Scripts, SQL Transactions, Transaction Log
1 Comment

This example of delayed durability runs 50,000 small transactions on SQL Server 2025 four ways and compares time and log writes. It shows what the database setting and the commit option change, and what you risk.

Continue Reading
Previous 1 … 414 415 416 417 418 419 420 … 847 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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