Can some experts can tell the usage of Sliding Window in SQL partitions?
And i was to have dynamic partitions on the table.
Today i have partition like below :
getdate() should to partition file 1
getdate() +1should to partition file 2
getdate()+1 >should to partition file 3
So next day
getdate() [mentioned in Day1]should move to file 2
getdate()+1 [mentioned in Day1]should move to file 3
getdate()[Day2] should move to file 1
Is can be achieved through Sliding Window