Partition by day of week.

Hi All,

I need to partition a table by day of week. We need to keep 7 days worth of
data and then we can truncate the oldest partition and start over again. 
has someone done so earlier ? What would be a better idea [Range or List ??]

If someone has an example that would be great .


Other related posts: