Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Procedure for T_SQL query optimization using Select and insert into on views RE: Procedure for T_SQL query optimization using Select and insert into on views

  • January 10, 2013 at 1:43 am

    #1575637

    Having two nested WHILE loops is likely to be a performance killer. See if you can rewrite them into a set-based operation. As Bhuvnesh mentions, please post table DDL and sample data if you need any further help.

    John