Home Forums SQL Server 2008 SQL Server 2008 - General How to avoid this T-SQL statement affecting my TempDB? RE: How to avoid this T-SQL statement affecting my TempDB?

  • August 29, 2012 at 1:00 am

    #1531229

    Is "ORDER BY C.FDDOC#, C.FDLINE" required?

    What is the type of C.FDLINE?

    Creating an index on C.FDDOC#, C.FDLINE should imporve the tempdb size and execution time.