Home Forums SQL Server 2008 SQL Server 2008 High Availability ODS - Operation Data Source with small data comapring to Production to gain performance. RE: ODS - Operation Data Source with small data comapring to Production to gain performance.

  • December 27, 2012 at 3:27 am

    #1571793

    How about snapshot ?

    we can take DB snapshots on PROD and execute ETL on snapshot. let me know your view / recommendation on this.