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
Jun26

SQL Server 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance

Pinal Dave
SQL Performance
Compatibility Level, MAXDOP, Parallel, Query Store, SQL CPU, SQL DMV, SQL Server 2022, SQL Server Configuration
No Comments

SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).

Continue Reading
Jun23

SQL Server Deadlocks – Interview Q and A

Pinal Dave
SQL Interview Questions and Answers
Deadlock, SQL Performance
1 Comment

Earlier this week, I wrote a few blog posts on SQL Server Deadlocks. Lots of people asked me if I could convert them into Interview Questions and Answers

Continue Reading
Jun22

SQL SERVER – Locking, Blocking, and Deadlocking: Differences, Similarities, and Best Practices

Pinal Dave
SQL Performance
Deadlock, SQL Lock
No Comments

Understanding SQL Server Deadlocks: A Beginner’s Guide, and after reading it, lots of people have asked me the difference between Locking, Blocking, and Deadlocking.

Continue Reading
Jun21

SQL SERVER – Resolving Deadlock by Accessing Objects in the Same Order

Pinal Dave
SQL Tips and Tricks
Deadlock, SQL Stored Procedure
1 Comment

In Understanding SQL Server Deadlocks, I mentioned that one way to avoid or resolve deadlock is by accessing objects in the same order.

Continue Reading
Jun20

Detecting Deadlocks in SQL Server Using Trace Flags 1204 and 1222

Pinal Dave
SQL Tips and Tricks
Deadlock, SQL Error Messages, TraceFlags
No Comments

Well, let us discuss Detecting Deadlocks in SQL Server Using Trace Flags 1204 and 1222. T-SQL for enabling, disabling, and checking the status of these trace flags.

Continue Reading
Jun19

Understanding SQL Server Deadlocks: A Beginner’s Guide

Pinal Dave
SQL Performance
Deadlock, SQL DMV
5 Comments

Welcome to this introductory blog post on SQL Server Deadlocks. In this post, we’ll help you understand what deadlocks are, and how they occur.

Continue Reading
Jun16

SQL SERVER Challenge – Cumulative Total Calculation

Pinal Dave
SQL Interview Questions and Answers
Contest, CTE, Ranking Functions, SQL Scripts, SQL Sub Query
2 Comments

Today we will see a very interesting SQL SERVER Challenge about Cumulative Total Calculation. During a recent Comprehensive Database Performance Health Check.

Continue Reading
Previous 1 … 38 39 40 41 42 43 44 … 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