Except for the dr_sk column, I don't see any other unique indexes on this table and that's a good thing for paritioning-sake.

What's the nature of the dr_frdatetime_hq column?

1. Is it assigned a value as part of the insert of the row? If not, is there such a date column in the table (we need one to partition)?

2. Is it (that column) ever updated?

The reason I ask is because (especially because of the indexes on this table) it looks like it might make a decent column to base monthly partitions on.

Also, (and I have to double-check when I get home) the existing constraints with the NO CHECK hint might be a problem for paritioning. IIRC, no constraints in a table can have the NO CHECK option if you want fully aligned partitions that can someday take advantage of SWITCH (out or in) but that might only apply to the parititioning column. Like I said, I have to double-echeck on that.