My biggest beef in SQL Server is the lack of Date fields (without time).
I am forever having to compare dates from '00:00' to '23:59' when the time is absolutely irrelavent.
I thought of using a character field to store dates but then the date functions are more complicated and there is no date checking...
Anyway, your comments are welcome.
For now, can someone tell me the easiest way to compare a datetime field with multiple times throughout the day to a single date (any time of day)?