Category: Execution Plan

Recently a good friend of mine asked me question whether is there any performance benefit in filtering the data out in subqueries, and then joining them. Well, answer

Hi Friends, Ever wanted to check the heartbeat of SQL Server. It is a very common activity for a SQL Server user to check CPU, SQL Memory Utilization,

I often see DBAs/developer struggling to find what’s wrong with query. The first step in troubleshooting queries is finding out information like batch text, query text, batch execution

Hi Friends, I often work on Performance Issues, and I found that developers use RECOMPILE option without even understanding it thoroughly. Instead of resolving the performance issue by

Hi Friends, this is my 3rd blog post of series Query Optimization. In last blog post Questions and Answers per Month, we took optimization decision by analyzing warnings

Hi Friends, this is my 2nd blog post of series Query Optimization. In 1st blog post What is my accepted answer percentage rate, we took optimization decision based

I am very often asked on how to start query tuning which gave me an idea to start a Query Tuning blog series. I shall be taking random

I often receive questions by developers and DBAs on how to find what’s the issue with their query or why it is so slow. This was a similar