• Please do NOT just try to implement partitioning without a VERY good knowledge of it and a VERY good understanding of WHY you think you need it in the first place!! It is a complex subsystem and I have lost track of the number of clients and forum posters that have messed things up with it!!

    Do your self and your company a HUGE favor and get a professional on board for a few days to help you understand your needs and potential solutions to problems!!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service