Posted inPerformance Tuning
First Responder Kit Power BI Dashboard
Recently Brent Ozar team added yet another great feature of Power BI Dashboard on data…
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 inPerformance Tuning TSQL
Common Myth: Loop is Always Faster than Cursor
From past few weeks, I have been taking interview for Sr. SQL DBA position in…
Posted inPerformance Tuning Powershell TSQL
Deploy SQL-Server-First-Responder-Kit with Powershell
There are many tools in market that can help you troubleshoot in specific situations. My…
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 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…