SELECT DATEADD(day,DATEDIFF(day,'19000101',GetDate()),'19000101')While it was not quite the fastest it was up there with another solution that is not in this thread. This solution he said was twice as fast as the others on 1,000,000 iterations.
>SELECT [Id] >FROM [MyTable] >WHERE YEAR(DateField) = YEAR(@DateField) AND > MONTH(DateField) = MONTH(@DateField) AND > DAY(DateField) = DAY(@DateField) >>