Home Forums SQL Server 2012 SQL Server 2012 - T-SQL SP with 3 parameters as delimited list - Goal 500 milliseconds RE: SP with 3 parameters as delimited list - Goal 500 milliseconds

  • June 30, 2016 at 3:46 pm

    #1887979

    Did you fix anything?? Looks mostly the same to me, just fatter tables and now you have spills on the big HASH join and a bajillion row nested loop.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service