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
key lookup

SQL SERVER Performance Tuning: Catching Key Lookup in Action

April 3, 2025
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, SQL Index

In this blog post, we’ll explore what a Key Lookup is, how to spot it, and most importantly, how to eliminate it using a covering index.

Read More
with recompile

SQL SERVER – Understanding WITH RECOMPILE in Stored Procedures

November 25, 2024
Pinal Dave
SQL Performance
Recompile, SQL Stored Procedure

The culprit? Parameter sniffing. The solution? You guessed it: WITH RECOMPILE. Comprehensive Database Performance Health Check

Read More
auto drop

Understanding the AUTO_DROP Option in SQL Server 2022

October 6, 2024
Pinal Dave
SQL Performance
SQL Statistics

One such feature is the AUTO_DROP option for statistics. In this blog post, we’ll explore what the AUTO DROP option is, how it works.

Read More
max server memory

Why ‘Max Server Memory’ Isn’t Always the Limit

August 20, 2024
Pinal Dave
SQL Performance
DBA, SQL Memory, SQL Server Management Studio

What if I told you that setting a limit with “max server memory (MB)” doesn’t always mean SQL Server will stick to that limit?

Read More
Extended Events

Capturing Stored Procedure Executions with Extended Events in SQL Server

July 11, 2024
Pinal Dave
SQL Performance
SQL Extended Events, SQL Stored Procedure

Capturing stored procedure executions with Extended Events: set up a session with module_end, run a sample procedure, and query the captured data.

Read More
Majoring in the Minors

Majoring in the Minors in SQL Server Performance Tuning

June 21, 2024
Pinal Dave
SQL Performance
Clustered Index, ColumnStore Index, Execution Plan, SQL Index

We’ll explore how to avoid this common pitfall & Focus the areas that matter for performance improvements. Avoid majoring in the minors. 

Read More
A hand tying one ribbon to each blackberry bush along a lane that has at least one ripe berry.

EXISTS vs IN vs JOIN: Writing Semi-Joins

June 1, 2024
Pinal Dave
SQL Performance
SQL Joins, SQL NULL, SQL Server, SQL Sub Query

Compare EXISTS, IN, and JOIN for semi-joins, prevent duplicate customer rows, and handle NULL safely in exclusion queries.

Read More
Previous 1 2 3 4 5 6 7 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com