• sometimes the prettier solutions perform far worse

    unfortunately SQL Server cares not one jot for the aesthetics of your code