Are there drawbacks to having a large
tempdb in a SQL Server database? Assuming the disk is not full.
I am creating large temporary tables in a couple of queries. Once I am finished running queries, I drop the temporary tables. However,
tempdb remains relatively large. Should I be worried about any subsequent problems with the server? Such as performance, or something I am not able to think of.