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.
SQL SERVER – Understanding WITH RECOMPILE in Stored Procedures
The culprit? Parameter sniffing. The solution? You guessed it: WITH RECOMPILE. Comprehensive Database Performance Health Check
Understanding the AUTO_DROP Option in SQL Server 2022
One such feature is the AUTO_DROP option for statistics. In this blog post, we’ll explore what the AUTO DROP option is, how it works.
Why ‘Max Server Memory’ Isn’t Always the Limit
What if I told you that setting a limit with “max server memory (MB)” doesn’t always mean SQL Server will stick to that limit?
Capturing Stored Procedure Executions with Extended Events in SQL Server
We’ll go through the steps to set up an Extended Events session, run a sample stored procedure, and then query the captured data.
Majoring in the Minors in SQL Server Performance Tuning
We’ll explore how to avoid this common pitfall & Focus the areas that matter for performance improvements. Avoid majoring in the minors.
SQL SERVER – Aligned and Non-Aligned Indexes for Partitioning
In the context of partitioning, it’s essential to understand the concepts of aligned and non-aligned indexes. Let us learn about it today.