How to measure the execution time of the stored procedure when it contains lots of statement inside of it. Let us learn today about Stored Procedures
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%.
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.
Today we will take the same conversation to the next level by discussing Single Scan for 3 Operations – COUNT(*) COUNT(1) SUM(1).
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.
One question that kept on coming up was SUM(1) vs COUNT(*) – Performance Observation. Well, let us see that today.