When attempting to sync an entity with many attributes, the initial sync or delta syncs will fail due to the sql row limit. This is a show stopper and the only workaround is to delete attributes from this entity in CRM until it's below the limit.
The underlying exception is:
Entity: publisher_entity, RecordId: dg67ce23-9e05-x311-w317-00505692015z, NotificationTime: 01/00/1900 12:15:35, ChangeType: Update, FailureReason: Cannot create a row of size 8064 which is greater than the allowable maximum row size of 8060.
The statement has been terminated.