I'd like to hear Hugo's answer to your question, but IMHO not much really changes in SQL Server 2008 with regard to the DATE and TIME data types. When working with time, you still will most likely need to use ranged searches in most of your queries. The DATE type, if used, would make it easier to find all records entered on a specific date, as you won't have to do a ranged search in that case.