• In my experience the most common setup that suits a separate reporting database where the indexes can be different from the primary database is Transactional Replication with a Continuous Push Subscriptions. This means that as soon as changes are committed to the Publisher database they are immediately Pushed to the Subscriber(s) making the data available to reports.

    Configuring, Modifying, and Disabling Publishing and Distribution (Replication) - SQL Server 2008 R2

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato