In SQL Server, is there any way to find when were the partitions created on the table?
Background: We have around 40 tables which are partitioned along with their indexes. We have total of 4 Filegroups. we have a windows service which is related to partitioning. what it does is, it creates new partitions if the number of records that reached some threshold(other logics are also there) and these partitions are created in one of the 4 filegroups in round robin fashion. we have lot of partitions. I want to know is there anywhere inside SQL Server, does it store the creation time of these partitions?
If not I will be shocked as I feel this is the basic which should be present in SQL Server no matter what. Please provide your inputs.