I have used lot of paging code in SQL Server 2008. The format is
With CTE( -- SQL With RowNumber ) -- SELECT ALL Page N
This is working fine. But I have heard that SQL Server 2012 has better paging support. So, if I change all my stored procedures with paging to the new method, will my queries be more efficient?