I've wondered about consolidating date and time into a single column. But I noticed that with SQL 2008, they now have capability for separate date and time, so I assumed there must be a need for that. I hesitated to make the change until I understood the pros and cons.