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.
Warm Holiday Wishes and Learning Opportunities! 🎄✨
I want to take a moment to extend my heartfelt wishes for a wonderful season and an even better year ahead. I have some learning opportunities for everyone in this blog post.Â
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.