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.