Today we are building a Collection of Articles that have recently generated interest on the blog as well as on the YouTube channel – SQL in Sixty Seconds.
COUNT(*) and COUNT(1): Performance Battle – which one is better for performance? I got this question after watching my previous video.
I discuss this during Comprehensive Database Performance Health Check. It is true that the identity Column is Difficult to Remove.