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

ANSI PADDING and Storage – SQL in Sixty Seconds 210

January 16, 2025
Pinal Dave
SQL Video
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.

Read More

SSMS and Execution Timeout – SQL in Sixty Seconds 209

January 13, 2025
Pinal Dave
SQL Video
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.

Read More
tempdb spills

Performance and TempDB Spills – SQL in Sixty Seconds 208

January 10, 2025
Pinal Dave
SQL Video
SQL Performance, SQL TempDB

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

Read More

Deadlock and Profiler – SQL in Sixty Seconds 207

January 8, 2025
Pinal Dave
SQL Video
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.

Read More
TOP PERCENT

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

January 6, 2025
Pinal Dave
SQL Video

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

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

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

Go to mobile version