Clarifying LEFT and RIGHT in the defintion of a PARTITION FUNCTION in SQL Server 2005
NOTE: Generally, I recommend RIGHT-based partition function so that you don't have to deal with datetime timetick issues at all. However, this post can really help