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
Apr14

OS Thread of a Session: Map Session ID to Windows Thread ID

Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Server
No Comments

To find the OS thread of a session, join sys.dm_os_tasks to sys.dm_os_threads on the worker address. This post reads the map for your own session and for every user session. It explains why idle sessions have no row, why parallel queries have several, and how to follow a thread in Performance Monitor.

Continue Reading
Apr13

sys.dm_exec_valid_use_hints: Every USE HINT Your Server Knows

Pinal Dave
SQL Performance
Parameter Sniffing, Query Hint, SQL DMV, SQL Scripts
No Comments

sys.dm_exec_valid_use_hints lists every USE HINT name that your SQL Server accepts. This post groups the 35 names on SQL Server 2025 and shows the compile error for a misspelled hint. It applies two hints and reads the plan to prove each one worked, then compares USE HINT with QUERYTRACEON.

Continue Reading
Apr12

JDBC and sendStringParametersAsUnicode: The Hidden Index Scan

Pinal Dave
SQL Performance
Java, SQL Datatype, SQL Index, SQL Server, Unicode
No Comments

Diagnose sendStringParametersAsUnicode conversions, align JDBC parameters with varchar indexes, and preserve required Unicode data.

Continue Reading
Apr9

SQL Puzzle – SELECT ~ 1 : Guess the Answer

Pinal Dave
SQL Puzzle
SQL Operator, SQL Scripts, SQL Server
124 Comments

SELECT ~ 1 returns -2 because the tilde is the bitwise NOT operator and flips all 32 bits of an int. This post keeps the puzzle, tests the answer on SQL Server 2025 with five data types and shows where the tilde is useful.

Continue Reading
Apr8

NOT IN With a NULL in the List Returns No Rows

Pinal Dave
SQL Tips and Tricks
SQL NULL, SQL Operator, SQL Server, SQL Sub Query
No Comments

See why NOT IN with a NULL returns no customers, then compare five sample rows, NOT EXISTS, an IS NOT NULL filter, and query plans.

Continue Reading
Apr7

Threads With Zero Rows in a Parallel Plan, Measured

Pinal Dave
SQL Performance
Execution Plan, MAXDOP, Parallel, SQL DMV, SQL Scripts
No Comments

A parallel plan can show threads with zero rows, and that is normal. This post reads the per-thread row counters of two real plans on SQL Server 2025 and shows where the empty threads come from. It also says when an empty thread points to a real problem.

Continue Reading
Apr6

Azure SQL Database Serverless: Auto-Pause and What Wakes It

Pinal Dave
SQL Tips and Tricks
Cloud Computing, DBA, SQL Azure
No Comments

Understand Azure SQL Database serverless limits, auto-pause, resume delays, and billing metrics before choosing an idle strategy.

Continue Reading
Previous 1 … 72 73 74 75 76 77 78 … 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