Our temptable seems to be growing and is not emptying out. Our DBAs can increase the temptable, but want to know if it can be managed within the tool.
Is there a method, SQL statement, or any kind of procedure to reduce or release "stale" data in the temptable in SQL?
The temp database is used by the SQL Server query optimizer. We do not interact directly with this database. Therefore, we do not have a method to be able to release space.