• Do you have the process that you are looking at as it might give people some pointers as to why this is happening.

    with my limited knowledge tempdb is used to hold worktables and so the CTE could be spilling results to the worktables when it needs to make way for new data coming in especially if the CTE has a DISTINCT, Group by or UNION in it.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices