I'm still new to usage of XML in database environnement (SQL 2005) and I'm wondering what's the best practices.
I have one table for user Event. They can schedule a event to be run many time during a day.
Ex: run at 8AM, 11AM, and 5pm
To save the schedule I see two different solution create table to save the hours (1 row by time) and link it to event table or used XML column in the Event table, to save the hours in XML collection.
What's the best solution and why?
can both solution be good in different case?