The maximum number of records determines how many records can be retrieved from the database. If the limit is too low, you aren't sorting on a complete set of records. If you need to work with all the records, raise the limit. If you don't need to work with all the records in the database, create a server filter to limit records to the subset you need.
I receive replication errors after I change the language sort order.
If you're synchronizing between replicas in a Microsoft SQL Server database or SQL Server 2000 Desktop Engine, you might encounter synchronization conflicts if the databases don't have the same language sort orders.