程序人生

摘要： Reference:http://blogs.msdn.com/b/felixmar/archive/2011/08/29/partitioning-amp-archiving-tables-in-sql-server-part-2-split-merge-and-switch-partitions.aspxIn the 1st part of this post, I explained how to create a partitioned table using a partition function as well as a partition schema. Now I’ll co 阅读全文

摘要： Reference:http://blogs.msdn.com/b/felixmar/archive/2011/02/14/partitioning-amp-archiving-tables-in-sql-server-part-1-the-basics.aspxDatabase partitioning is a feature available in SQL Server(version 2005 and Up) which lets you split a table among multiple files which can be beneficial for large tabl 阅读全文