We have an OLTP application for which a majority of the database's tables are replicated between two environments.
The publisher side is intended to handle the writes from users and the subscriber handles the reporting aspect of the application.
The subscriber therefore is mainly read by users and should only be updated by replication.
Should I alter the fill factor on the subscriber's indexes to be higher percentage than the publisher or should they be the same as the publisher?
February 6, 2009 4:17 PM
February 6, 2009 4:31 PM