Sql Server Dynamic Database Partitioning
Is there anything called dynamic partitioning in SQL server? If开发者_运维技巧 so how can i implement it?
You can have an automatic sliding window table partition that will keep say the last X days data in one partition and move everything else
http://technet.microsoft.com/en-us/library/aa964122(SQL.90).aspx
精彩评论