With every new version of SQL Server comes new and hopefully improved functionality. When SQL Server introduces a new function that sometimes overlaps or replaces the functionality of an already existing function, I am usually curious as to which performs
