December 9, 2014 at 4:26 am
What is the maximum no.of global temporary tables can create in sql server
December 9, 2014 at 4:34 am
There is no limit on the number of the Global temporary tables you create in sql server.
Memory is limit...!!! 😎
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 10, 2014 at 2:24 am
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.
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
December 10, 2014 at 3:09 am
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.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
December 10, 2014 at 3:19 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply