
One of the listed fixes in SNC 02 for Saleslogix 8.1 is listed as:
14095222 Enhance the SQL generation to use OFFSET/FETCH for SQL Server 2012 for paged queries.
However, it utilizes SQL 2012 commands that are not supported on SQL2008R2 and therefor groups no longer function after applying.
Thanks Jeremy!