I have a simple script that will list all the long running queries in the database with the execution plan. Well, the answer is yes.
SQL SERVER – JOIN Elimination for Not Selected Column
The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.
SQL SERVER – 16 CPU vs 1 CPU : Performance Comparison – SQL in Sixty Seconds #142
Well, let us figure out the answer to this question in today’s blog post where I will be doing a performance comparison of 16 CPU vs 1 CPU.
SQL SERVER – Multiple Optimize Hint for a Query
An interesting question asked by one of my clients. The question was how to have multiple optimize hints for a query. Let us learn.
SQL SERVER – Distinct and ORDER BY
I have made note that ORDER BY is not required when DISTINCT is used. Let us understand the same subject in detail. Let us learn today.
SQL SERVER – Scan Count Zero for Statistics IO
On the production server and they noticed scan count as Zero on the result. They reached out to me asking what actually it means.
Arrow in Execution Plan – SQL in Sixty Seconds #136
Do you know what a single arrow means in an execution plan? While we popularly call it the arrow, there is a technical name for these little arrows.