I thought of extending SQLServer2012Dialect myself to implement pagination with hibernate standard setFirstResult/setMaxResults calls.
Some said I have to extend LimitHandler as well.
I had no internal knowledge of Hibernate but thought that for someone who is into it should not take very long.
Unfortunately I have to stick to MSSQL for this project