Home Forums SQL Server 2008 T-SQL (SS2K8) Multiple UNION ALL queries cause SSMS to hang/freeze up/ slow down? RE: Multiple UNION ALL queries cause SSMS to hang/freeze up/ slow down?

  • February 11, 2011 at 5:00 pm

    #1285959

    I am joining two CTEs and then UNION ALL and repeating.

    So

    CTE1 JOIN CTE2

    UNION ALL

    CTE1 JOIN CTE3

    UNION ALL

    CTE1 JOIN CTE4

    etc..

    The slowness is when I physically scroll through the TSQL text inside SSMS.

    I think I have RedGate SQL Search and prompt, I'll try turning those off and checking again.