0

how can I partition my table into two. One with latest one month data and the rest into another partition? I am using SQL Server 2012 Standard Edition.

Pandiarajan
  • 410
  • 5
  • 14
  • 1
    Based on the linked question above: you can do this, but it isn't going to be useful because SQL Server will not move existing data to another partition. – Richard Mar 12 '18 at 10:12
  • 1
    SQL Server 2012 Standard Edition does not support partitioning. – MJH Mar 12 '18 at 10:20

0 Answers0