SQL 2008 introduces the new DATE data type, and it is considerable quicker to CAST a DATETIME to this if you’re attempting to just extract the date part from a DATETIME field, than using the old method of SELECT CONVERT (DATETIME,CONVERT(CHAR,GETUTCDATE(),102))
Read More...