• Just remember that partitioning the table wont make your queries faster.

    For an explanation much better than i can provide myself please see this link

    https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/