Home Forums SQL Server 2008 T-SQL (SS2K8) Table variable is not automatically dropped in TempDB RE: Table variable is not automatically dropped in TempDB

  • April 30, 2013 at 3:31 am

    #1611148

    GilaMonster (4/30/2013)

    Temp table caching was added in SQL 2005 to alleviate the contention on the TempDB allocation pages caused by frequent creation of temp tables.

    I wish that would be a bottleneck in our systems...

    :hehe:

    _____________
    Code for TallyGenerator