The number one question when showing multiple ways to return the same result set in SQL Server is, "which one performs better?" For this post I'm going to compare COUNT vs. SUM on 1 million rows, ...
Part 1: https://www.linkedin.com/pulse/count1-count-sql-server-th%E1%BA%BF-nguy%E1%BB%85n-kh%E1%BA%AFc-ita0c/?trackingId=L0dXQR9RucIjYkCoMQYUUQ%3D%3D Part 2: https ...