Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Global Temp Table RE: Global Temp Table

  • December 10, 2014 at 3:19 am

    #1763717

    Jason-299789 (12/10/2014)

    GilaMonster (12/10/2014)

    Probably the limit of the number of objects in a database. That's 2.3 billion, give or take.

    Memory is NOT the limit as temp tables are not memory-only.

    Over and above the 2.3 billion due to internal references, wont the limiting factor be available space within the Temp DB.

    Indeed. The space available to TempDB on disk is far more likely to prevent more temp tables (global or otherwise) than anything else.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass