Blog Home Page - SQL Authority with Pinal Dave

May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Apr23

SQL SERVER – Catching Non-SARGable Queries in Action

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.

Apr3

SQL SERVER Performance Tuning: Catching Key Lookup in Action

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.

Jan16

ANSI PADDING and Storage – SQL in Sixty Seconds 210

SQL Data Storage, SQL Server Configuration

ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR and VARCHAR.

Jan13

SSMS and Execution Timeout – SQL in Sixty Seconds 209

SQL DateTime, SQL Server Management Studio, SSMS

Execution timeout in SSMS are a small but important feature that can help you manage query performance. Let us watch the video together.

Jan10

Performance and TempDB Spills – SQL in Sixty Seconds 208

SQL Performance, SQL TempDB

Sorting large datasets in SQL Server can significantly impact performance, especially when it leads to tempdb spills.

Jan8

Deadlock and Profiler – SQL in Sixty Seconds 207

Deadlock, SQL Performance, SQL Profiler

In today’s episode, we’ll explore how to simulate and capture deadlocks in SQL Server using the powerful SQL Server Profiler.

Jan6

TOP vs. TOP PERCENT: Hidden Costs – SQL in Sixty Seconds 206

The hidden costs of using TOP versus TOP PERCENT clauses. Even if the results appear the same, the underlying performance can vary.

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 90 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 an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@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.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.