Tag: Query Tuning

In my current organization, we have lot of servers where database mirroring is used as a disaster recovery option. Either we are setting up mirroring from scratch or

Today, I was working on an incident of slow running procedure. Procedure was running fine for most of the parameter values but, was getting stuck for few values.

It is not a new thing for a DBA to check what’s running currently on server in order to figure out issues. My personal favorite tool for finding

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

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 are multiple articles on internet regarding Query Shortcuts in SQL Server Management Studio. So I won’t cover details of SSMS Query Shortcuts. But to increase your productivity, I