I don't mind having these be cleaned up by the system. Unless I have a big temp table and expect
to create another big one (you might want to avoid having these two at the same time).
You need the space in tempdb that you need. To reduce the amount of space needed, you could
check indexes, queries, query plans etc. Also, you can specify that tempdb is created with your
desired size at startup (ALTER DATABASE).
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...
> Am using a series of temp tables in a procedure.
> Is it good programming to drop the temp tables once am done with it (i
> mean half way in the procedure I know am not going to call a particular
> temp table again)in the procedure or can we just leave to die out once
> the session is over.
> Do we care about the growth of the temdb?
> -- Raj
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!