After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.
Cost Relative to the Batch: Why One Query Shows 100%
Cost relative to the batch is a share of estimated cost. See why one query shows 100% and when the percent points at the wrong statement.
Query Hints on a View in SQL Server: Where OPTION Goes
Query hints on a view cannot sit inside the view. Learn where OPTION goes, what a view may contain, and how Query Store hints help.
One Scan for 3 Count Sum – SQL in Sixty Seconds #178
Well, the answer is pretty straight forward and that is what we are going to see in today’s video of One Scan for 3 Count Sum.
SQL Server – Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1)
Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).
SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177
Based on my recent two videos, I got lots of questions about SUM(1) vs COUNT(1) Performance Battle. Let us see that in today’s video.
SQL SERVER – SUM(1) vs COUNT(*) – Performance Observation
My Performance Observation found similar counting plans for a nonempty table. SUM(1) and COUNT(*) still differ on empty input.