Can anybody tell me how to automate sliding partition?
I have a table having 2 yrs data and it has a datetime column
i partitioned it in to 13 partitions based on the datetime column. one partition for one quarter. so it can store the data up to 3 yrs(12 quartes) 1 extra
partition for next used.
13 .NDF Files
13 File Groups