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 inErrors Performance Tuning
Analyzing Deadlock Issues
I often receive the question - what is the best way to find issues when…
Posted inDatabase Administration
Setup fresh/Scriptout Existing Mirroring on SQL Server
In my current organization, we have lot of servers where database mirroring is used as…
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…
![Result Set of [sp_WhoIsActive]](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2016/12/Log_Activities-02-1.png?fit=1024%2C437&ssl=1)
Posted inPerformance Tuning
Log all Activities using sp_WhoIsActive
It is not a new thing for a DBA to check what's running currently on…
![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…
![Query Optimization 01 – What is my accepted answer percentage rate [StackOverflow]](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2016/11/EP-04.png?fit=1024%2C266&ssl=1)
Posted inExecution Plan Performance Tuning
Query Optimization 01 – What is my accepted answer percentage rate [StackOverflow]
I am very often asked on how to start query tuning which gave me an…
Posted inExecution Plan Performance Tuning
Why my query is slow?
I often receive questions by developers and DBAs on how to find what's the issue…