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
Nov11

Error 17182: Unable to Initialize SSL Support in SQL Server

Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages, SQL Log, SQL Server Installation, SQL Server Security
4 Comments

Error 17182 says the client and server do not possess a common algorithm. A client could not install SQL Server 2014 because the build did not support TLS 1.2. Switching protocols, patching and switching back fixed it.

Continue Reading
Nov10

How to Write INNER JOIN Which is Actually CROSS JOIN? – Interview Question of the Week #250

Pinal Dave
SQL Interview Questions and Answers
SQL Joins, SQL Scripts, SQL Server
3 Comments

Question: How to Write INNER JOIN Which is Actually CROSS JOIN?

Experienced this question another day while working with a client.

Continue Reading
Nov9

RID Lookups on Heaps vs Key Lookups on Clustered Tables

Pinal Dave
SQL Performance
Clustered Index, Execution Plan, SQL Heap, SQL Index, SQL Server
No Comments

Compare RID lookups on heaps with clustered key lookups, inspect forwarded records, and test covering indexes with actual plans and reads.

Continue Reading
Nov8

ABORT_QUERY_EXECUTION: Stopping a Runaway Query With a Query Store Hint

Pinal Dave
SQL Performance
Query Hint, Query Store, SQL Performance, SQL Scripts
No Comments

ABORT_QUERY_EXECUTION is a SQL Server 2025 Query Store hint that makes one known bad query fail before it uses any CPU. This post sets the hint, shows the exact error the caller gets, lists and clears the hint, and covers the traps: exact text, SET options and queries already running.

Continue Reading
Nov7

Estimated Plan With a Temp Table: Why It Guesses One Row

Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server Management Studio, Temp Table
No Comments

An estimated plan for code that fills a temp table guesses one row for every read of that table. This post compares the estimated plan and the actual plan on SQL Server 2025, shows where the numbers split, and explains when to trust each one.

Continue Reading
Nov6

Sequence Project and Segment: How Window Functions Show Up in a Plan

Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Scripts
No Comments

A window function leaves Segment and Sequence Project operators in a query plan, and a Sort in front of them. This post tests ROW_NUMBER and a running total on SQL Server 2025, shows the batch mode Window Aggregate that replaces them, and removes the Sort with an index.

Continue Reading
Nov5

The Filter Operator: When SQL Server Reads Everything and Keeps a Few Rows

Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Scripts
No Comments

The Filter operator keeps a few rows after the plan has read and sorted many more. This post shows one on SQL Server 2025 with the actual plan and the logical reads, then rewrites the query so it seeks instead and reads about a fifth as many pages.

Continue Reading
Previous 1 … 140 141 142 143 144 145 146 … 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