• My advice is to set up a test and actually do it to verify (and learn in the process). Partitioning REALLY isn't something you want to learn about from some forum posts and then roll into production! 🙂

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