Posted inExecution Plan Performance Tuning TSQL
Question/Answer – Should I filter the data in Sub Queries??
Recently a good friend of mine asked me question whether is there any performance benefit…
![Should we check [context_switches] for SQL Server Query from Performance Point](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/05/Context-Switches.png?fit=1024%2C252&ssl=1)
Posted inPerformance Tuning TSQL
Should we check [context_switches] for SQL Server Query from Performance Point
Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server…
![[sp_HealthCheck] – Get SQL Server Health Details](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/03/sp_HealthCheck.gif?fit=1024%2C500&ssl=1)
Posted inExecution Plan Health Check
[sp_HealthCheck] – Get SQL Server Health Details
Hi Friends, Ever wanted to check the heartbeat of SQL Server. It is a very…
Posted inExecution Plan Health Check Performance Tuning TSQL
What’s Running – Find All Details of Running Queries
I often see DBAs/developer struggling to find what's wrong with query. The first step in…
Posted inExecution Plan Performance Tuning
Procedures with RECOMPILE Option
Hi Friends, I often work on Performance Issues, and I found that developers use RECOMPILE…
Posted inInternals Performance Tuning TSQL
Non – Trusted Foreign Keys in SQL Server
Today, I was working with one user to troubleshoot their query timeout issues. Analyzing wait…
Posted inPerformance Tuning
Log all Activities using sp_WhoIsActive – 2
Hi Friends, in my previous blog post Log all Activities using sp_WhoIsActive, I shared how…
Posted inPerformance Tuning TSQL
Optimize for Value – TSQL Query Hint
Today, I was working on an incident of slow running procedure. Procedure was running fine…
![Query Optimization 03 – Users statistics (individual user) [StackOverflow]](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2016/11/Execution-Plan-02.png?fit=1024%2C576&ssl=1)
Posted inExecution Plan Performance Tuning TSQL
Query Optimization 03 – Users statistics (individual user) [StackOverflow]
Hi Friends, this is my 3rd blog post of series Query Optimization. In last blog…
![Query Optimization 02 – Questions and Answers per Month [StackOverflow]](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2016/11/Sort-Spill-01.png?fit=576%2C349&ssl=1)
Posted inExecution Plan Performance Tuning
Query Optimization 02 – Questions and Answers per Month [StackOverflow]
Hi Friends, this is my 2nd blog post of series Query Optimization. In 1st blog…