These are enabled by default on indexes. SQL Server 2008 R2 also supports table partitioning. Because partitions divide data into separate objects, partitioning tables can improve overall performance.

However setting up tens or even possibly hundreds of partitions in BIDS manually is no-one’s idea of fun, so how can you automate this process easily? If you’re using a SQL Server datasource then you ...