Performance Tuning Archives - Page 4 of 4 - Performance Tuning And Infra Automation

Query Optimization 02 – Questions and Answers per Month [StackOverflow]

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 on Logical…

Ajay Dwivedi November 21, 2016

Execution 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 idea to start a Query Tuning blog series. I shall be taking random and slow…

Ajay Dwivedi November 14, 2016

Execution Plan Performance Tuning

Why my query is slow?

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 case. One…

Ajay Dwivedi November 12, 2016

Errors Internals Performance Tuning

Performance Tuning With Predicate Logic

I have often seen Developers write predicate logic without bothering about performance. That works most of the time. But what about queries that return huge data sets? Is there any…

Ajay Dwivedi October 15, 2016

Performance Tuning TSQL

Relationship data in Easy Way

Recently I worked on one optimisation job. It was procedure that processed multi-relationship data provided by clients in excel format, and created relationship tables. For example data like :- 1)…

Ajay Dwivedi September 27, 2016