Home Forums SQL Server 2005 T-SQL (SS2K5) Best approach for Data transfer of large number of rows RE: Best approach for Data transfer of large number of rows

  • If the databases are on the same server, you can use SQL scripts.

    Make sure logging is minimized to reduce overhead.

    What kind of performance issues were you having with the denormalized system?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP