If you ever wondered why a query that looks harmless is performing poorly despite having indexes in place, the answer could non-SARGable queries.
SQL SERVER Performance Tuning: Catching Key Lookup in Action
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.
ANSI PADDING and Storage – SQL in Sixty Seconds 210
ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR and VARCHAR.
SSMS and Execution Timeout – SQL in Sixty Seconds 209
Execution timeout in SSMS are a small but important feature that can help you manage query performance. Let us watch the video together.
Performance and TempDB Spills – SQL in Sixty Seconds 208
Sorting large datasets in SQL Server can significantly impact performance, especially when it leads to tempdb spills.
Deadlock and Profiler – SQL in Sixty Seconds 207
In today’s episode, we’ll explore how to simulate and capture deadlocks in SQL Server using the powerful SQL Server Profiler.
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.