Pagination options SQL 2012 vs 2008 (Performance perspective)

• npranj

  SSCrazy

  Points: 2323

  More actions

  September 2, 2013 at 4:03 am

  #297400

  Comparison with respect to performance - pagination options:

  1. SQL 2012 has introducted FETCH OFFSET ...

  2. SQL 2008 has an option of ROW_NUMBER() using CTE and then pick up specific row numbers.