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
Oct1

MAXDOP Query Hint: Override the Server Setting for One Query

Pinal Dave
SQL Performance
MAXDOP, Parallel, SQL Scripts, SQL Server Configuration
No Comments

The MAXDOP query hint sets how many processors one query can use, whatever the server setting says. This post proves it in both directions on a test table, shows that the hint can’t force a parallel plan and adds the database scoped setting between the two. Every step leaves the server setting alone.

Continue Reading
Sep30

Columnstore Indexes Without Aggregation: Do They Still Help?

Pinal Dave
SQL Performance
ColumnStore Index, SQL Index, SQL Scripts
No Comments

Columnstore indexes without aggregation still help when a query reads many rows but only a few columns. This post builds a rowstore table and a columnstore copy of one million rows and compares reads, size and execution mode. It also shows the case where a plain b-tree index wins.

Continue Reading
Sep29

How to Download the Latest SQL Server Docker Image? – Interview Question of the Week #244

Pinal Dave
SQL Interview Questions and Answers
Docker, PowerShell, SQL Scripts, SQL Server
No Comments

Question: How to Download the Latest SQL Server Docker Image? Answer: The command to download the latest SQL Server Docker Image is here:

Continue Reading
Sep28

Idle CPU Condition in SQL Server Agent: How It Works

Pinal Dave
SQL Tips and Tricks
SQL CPU, SQL Server Agent, SQL Server Management Studio
No Comments

The idle CPU condition tells SQL Server Agent when the CPUs are quiet enough to start a job. This post shows where to set it, how the two numbers work and how to create the schedule. It also reads the CPU history of your server in T-SQL, so you can choose values that the server can actually meet.

Continue Reading
Sep27

SQL SERVER – Strange Error Related to Alias

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server
1 Comment

They immediately paid for Comprehensive Database Performance Health Check and we got online to look at their strange error related to alias.

Continue Reading
Sep26

SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value

Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Error Messages, SQL Memory, SQL Scripts, SQL Server, Starting SQL
7 Comments

After incorrectly setting max server memory to 14 MB instead of 145000, a client could not start SQL Server. Here is how we got it back online.

Continue Reading
Sep25

ROWCOUNT_BIG and @@ROWCOUNT: Checking What a Statement Changed

Pinal Dave
SQL Tips and Tricks
Output Clause, SQL Function, SQL Scripts, SQL Server, SQL Trigger
No Comments

Capture ROWCOUNT_BIG immediately after a change, validate expected counts, and handle NOCOUNT, triggers, and MERGE without stale values.

Continue Reading
Previous 1 … 146 147 148 149 150 151 152 … 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