Home Forums SQL Server 2008 T-SQL (SS2K8) problem in select command RE: problem in select command

  • March 18, 2013 at 3:21 pm

    #1598189

    Lynn Pettis (3/18/2013)

    So a derived table in a FROM clause would have the same problem, wouldn't it.

    It would seem that a view would also have the same issue as well.

    Definitely not.

    You may write a horrible query causing a huge hash join and see tempdb filled with data with no temporary objects created in it.

    _____________
    Code for TallyGenerator