May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Catching Non-SARGable Queries in Action

April 23, 2025
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, Performance Schema, SQL Index

If you ever wondered why a query that looks harmless is performing poorly despite having indexes in place, the answer could non-SARGable queries.

Read More
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
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

SQL SERVER – Performance: OR vs IN

September 11, 2023
Pinal Dave
SQL Performance
Execution Plan, SQL Server Management Studio, SQL Statistics, SSMS

I recently asked on Twitter an exciting question about OR vs IN. While I got lots of good answers, there were an equal amount of wrong answers.

Read More
Parameter Sensitive

Parameter Sensitive Plan optimization in SQL Server 2022 – SQL in Sixty Seconds #200

May 16, 2023
Pinal Dave
SQL Video
Execution Plan, Parameter Sniffing, SQL in Sixty Seconds, SQL Performance

SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries.

Read More

Remove Key Lookup – SQL in Sixty Seconds #194

February 21, 2022
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Index, SQL Performance, SSMS

Today, we are going to see one more trick from the book – Remove Key Lookup and improve the performance of queries.

Read More

SQL SERVER – Is Query from Cache? Execution Plan Property

December 2, 2021
Pinal Dave
SQL Server
Execution Plan, SQL Cache, SQL Memory, SQL Scripts, SQL Server

Well, of course, there is an easy way to know this and that is Execution plan property. Is there any way to know if the executed query is from cache or not?

Read More
1 2 3 4 … 18 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version