I think I may have gotten it..but if anyone has any comments, the T-SQL code is below

CREATE PARTITION FUNCTION [ProductArchivePF2]

(

datetime

)

AS RANGE RIGHT

FOR VALUES ('12/1/2010')

CREATE PARTITION SCHEME [ProductArchivePS2]

AS PARTITION [ProductArchivePF2]

ALL...

If that's the case, I could make them integers and just translate them using a look up table.

Thoughts?

Thanks everyone for you help. I really wanted to make sure I was headed in the right direction because our existing database(s) design is experiencing timeouts, deadlocks, and latency...

Thanks allmhuran for the reply.

I've looked at table partitioning but not exactly sure how to implement it because all the examples I've seen is by range, not a...