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.
What is EDGE in SQL Server Execution Plan? – Interview Question of the Week #298
Question: What is EDGE in SQL Server Execution Plan?
Answer: It is the arrow or the line which goes from one operator to another operator.
SET STATISTICS IO ON – SQL in Sixty Seconds #128
I am working with clients on helping them tune their SQL Server Performance. Let us learn how we can use SET STATISTICS IO to check the query’s performance.
Full-Screen Execution Plan – SQL in Sixty Seconds #117
There are two primary tools – 1) Execution Plan and 2) Statistics IO. In this blog post, we will see how we can get the full-screen execution plan.Â
Activity Monitor and Running Query – SQL in Sixty Seconds #115
Activity Monitor can come handy when you are in trouble as well. We will see how we can take the help of Activity Monitor to track Actively Running Query.