SQL Server 2008 R2 is a significant release in the SQL Server family, offering many enhancements and new features compared to its predecessors. Some of the key features of SQL Server 2008 R2 include: