With end of support looming for Windows Server 2008 and SQL Server 2008, Microsoft has a new option for those users to keep getting security updates: By moving workloads to Azure.

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.