Hi, Chris,
Thanks for such a prompt support!
Though I had an impression that proper pagination in MSSQL started with 2012.
Syntax is like:

select *
from tender
order by id desc
OFFSET 1 ROWS FETCH NEXT 5 ROWS ONLY;

Not sure how 2008 LimitHandler will take care of 2012 SQL syntax.