select top 2 t.Name, t.Date from
(
  select row_number() over(partiton by name, date order by name, date desc) as rowno, Name, Date
  from MyTableNameHere
) as t
where t.rowno=1