There is a requirement to use offset / limit that the query contain an order-by clause. This means that SQLServer2012LimitHandler will examine the SQL for this clause and if found, will use the offset / limit clauses; however if the query isn't ordered, the dialect will fall back to using the SQLServer2005LimitHandler behavior which you currently see being used now.