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
Aug13

Windows Power Plan for SQL Server: Use High Performance

Pinal Dave
SQL Performance
Hardware, SQL CPU, SQL Server Configuration, Windows
2 Comments

The Windows power plan decides how fast the processors run, and an energy saving plan can slow SQL Server without raising any error. This post shows how to check the active plan, how to switch it and undo the change, and how to time the difference with a repeatable T-SQL loop.

Continue Reading
Aug12

Signal Waits: Detect CPU Pressure With Wait Statistics

Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Wait Stats
No Comments

Signal waits are the part of every wait that a task spends in the queue for a free CPU. This post ranks the wait types by signal time, shows why timer waits ruin the total share, and samples the signal share into a small table so a whole working day can be read interval by interval.

Continue Reading
Aug11

How to Skip Top N Rows in SQL Server? – Interview Question of the Week #237

Pinal Dave
SQL Interview Questions and Answers
Ranking Functions, SQL Function, SQL Paging, SQL Scripts, SQL Server
1 Comment

Question: How to skip top N Rows in SQL Server and retrieve the rest of the rows? Answer: I had asked the above question in one of the interviews last week.

Continue Reading
Aug10

WMI Invalid Class: Patch Rule Fails on Cluster Service Check

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Patch, SQL Server, SQL Server Cluster, Windows
12 Comments

A WMI invalid class error can sit behind a patch rule failure that looks like a cluster problem. The rule was Not clustered or the cluster service is up and online. Recompiling the WMI MOF files with mofcomp fixed it for my client.

Continue Reading
Aug9

THREADPOOL Waits: When Raising Max Worker Count Helps

Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Server Configuration, SQL Wait Stats
2 Comments

THREADPOOL waits mean tasks waited for a worker thread. Five read-only queries separate real thread starvation from blocking and busy CPUs. The post lists five signs and shows how to raise the cap in small steps.

Continue Reading
Aug8

Delete the Wrong Row: A Cheap Answer That Passes the Test

Pinal Dave
SQL Puzzle
SQL Delete, SQL Performance, SQL Scripts
5 Comments

A cheap answer to the multiple table delete puzzle reads only 6 pages and passes the check. It can still delete the wrong row. This post shows the answer, asks you to find the row it removes by mistake, and fixes it with a delete that costs 5 reads.

Continue Reading
Aug7

Max Worker Count: Why Typing 10000 Slowed a Server

Pinal Dave
SQL Tips and Tricks
SQL CPU, SQL DMV, SQL Scripts, SQL Server Configuration
7 Comments

Max worker count looks like a speed dial but behaves like a safety limit. A client typed 10000 on an 8 processor server and slowed it, and a reset to 0 fixed it in minutes. Two read-only queries show your value and whether workers run short.

Continue Reading
Previous 1 … 153 154 155 156 157 158 159 … 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