Temp Table size limitation?

[Deeba]

Hi,
Does SQL Server 7 have any sort of size limitation on it's temporary tables?

Thanks

 

[tlbroadbent]

The only limitations that I am aware of are the database limit of 1 TB and the physical limitations of the disk holding tempdb.

Practically speaking, you should limit the size of temporary tables because of the impact on peformance. If temporary tables are large and multiple temp tables are created by various users, available disk space could be quickly used and SQL perforamnce could degrade. Even a single large temp table can degrade performance. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Deeba]

Thanks Terry, I couldn't find that info anywhere.

~Deeba~