So what does SQL Server 2012 have to offer over SQL Server 2008 R2? Following is an overview of the new features provided in SQL Server 2012:
New storage features—Columnstore indexes, FileTable storage.
New Transact-SQL (T-SQL) constructs—Sequence objects,
THROW statement, new conversion, logical, string, and date and time functions, and ad hoc query paging.
New scalability and performance features—Indirect checkpoints, ...