Ok, 1 quick question.

So, I want to modify the partition function to be based on years...but is it really as simple as turning this:

create partition function pfDaily (datetime)

as RANGE RIGHT for values(

'2005-05-07', '2005-05-08', '2005-05-09', '2005-05-10', '2005-05-11', '2005-05-12', '2005-05-13', '2005-05-14',

'2005-05-15', '2005-05-16', '2005-05-17', '2005-05-18', '2005-05-19', '2005-05-20', '2005-05-21', '2005-05-22',

'2005-05-23', '2005-05-24', '2005-05-25', '2005-05-26', '2005-05-27', '2005-05-28', '2005-05-29', '2005-05-30',

'2005-05-31', '2005-06-01', '2005-06-02', '2005-06-03', '2005-06-04', '2005-06-05', '2005-06-06', '2005-06-07',

'2005-06-08', '2005-06-09', '2005-06-10', '2005-06-11', '2005-06-12', '2005-06-13', '2005-06-14', '2005-06-15',

'2005-06-16', '2005-06-17', '2005-06-18', '2005-06-19', '2005-06-20', '2005-06-21', '2005-06-22', '2005-06-23',

'2005-06-24', '2005-06-25', '2005-06-26', '2005-06-27', '2005-06-28', '2005-06-29', '2005-06-30', '2005-07-01',

'2005-07-02', '2005-07-03', '2005-07-04')

and making it this:

create partition function pfDaily (datetime)

as RANGE RIGHT for values(

'2005-10-01', '2006-10-01', '2007-10-01', '2008-10-01', '2009-10-01', '2010-10-01', '2011-10-01', '2012-10-01')

What I'm trying to do here is to create a seperare partition for each year, and I'm defining a year as 10-01-XXXX through 9-31-XXXX.

Does that make sense?