• Can you explain what you mean by is partitioning working?

    If you have partitioned the table and have data that belongs on multiple partitions and the data is on the multiple partitions then partitioning is working. Are you getting a performance benefit from partitioning is a different question. Here's a good article by Gail Shaw about partitioning and query peformance, https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/ that I found on Brent Ozar Unlimited's partitioning resources page, http://www.brentozar.com/sql/table-partitioning-resources/