See Message #1219621 in this thread.

>Itzik Ben-Gan outlined three methods in the Feb. 2007 issue of SQL Server magazine. His preferred method is this:
>
>

>
>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.
>