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.
SQL in Sixty Seconds – CPU Threads and Uneven Workload
When SQL Server executes a query in parallel, CPU threads often share the workload unevenly. Some handle a significant portion of the rows, while others manage much less.
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.