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
Apr2

SQL SERVER – A Brief History of Deadlock and Modern Approach of Resolution

Pinal Dave
SQL Performance
Deadlock, Quest, Webinar
No Comments

A deadlock investigation needs the graph and cooperation between DBAs and developers. I distinguish a blocking wait from a cyclic dependency.

Continue Reading
Apr1

Async Statistics Updates: Stopping Queries From Stalling

Pinal Dave
SQL Performance
SQL Performance, SQL Server, SQL Statistics
No Comments

Diagnose synchronous statistics refresh waits, enable async statistics updates, and judge when fresh estimates still matter more.

Continue Reading
Mar31

How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? – Interview Question of the Week #218

Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL String
1 Comment

How do you limit the output of Varchar(max) or Nvarchar(max) in a SELECT statement? A simple trick does it, and it works for varbinary(max), text and ntext too.

Continue Reading
Mar30

Consulting Wrap Up – What Next and How to Get Started

Pinal Dave
SQL Performance
Best Practices, Comprehensive Database Performance Health Check, Consulting, DBA, SQL Server
4 Comments

Use this consulting wrap up to keep a practical engagement checklist, choose the right service, and prepare the first email to get started.

Continue Reading
Mar29

Consulting 105 – Why Don’t I Want My Customers to Return for the Same Problem?

Pinal Dave
SQL Performance
Best Practices, Comprehensive Database Performance Health Check, Consulting, SQL Performance, SQL Server
No Comments

Learn to diagnose the same problem yourself, distinguish symptom relief from a root-cause fix, and know when a follow-up is useful.

Continue Reading
Mar28

Consulting 104 – Why Do I Give All the Performance Tuning Scripts to My Customers?

Pinal Dave
SQL Performance
Best Practices, Comprehensive Database Performance Health Check, Consulting, SQL Scripts, SQL Server
4 Comments

Keep performance tuning scripts with explanations, before-values, undo steps, and a configuration history your team can compare later.

Continue Reading
Mar27

Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours?

Pinal Dave
SQL Performance
Comprehensive Database Performance Health Check, Consulting, SQL Performance, SQL Server, SQL Wait Stats
No Comments

See how performance optimization in 4 hours follows focused triage, reviewed fixes, and a written action plan for the work that remains.

Continue Reading
Previous 1 … 172 173 174 175 176 177 178 … 846 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