I am working a report, where in the result is combination of multiple #temp tables. Structure is as below
Stored procedure 1 which has a temp table which gives a 0.5 million rows
Stored procedure 2 which has a temp table which give 0.1 million rows
Finally i need to combine the result set of above 2 SP , again use a temp table and make one final result set for report. Now i am worried about the performance, later if data increases, will it effect temp db. We usually stage the data monthly , in a month it Database may contain about 1 million rows. How much is the maximum capacity temp db accommodates. Will it effect with above approach.
Copyright Notice:Content Author:「Thomas_ITsavvy」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/30771549/temp-db-advice-using-temporary-tables