I'm not sure if the queries I am using are accurate.
Can anyone vouch for them?
EXEC sp_SpaceUsed
[database_name][database_size][unallocated space]
tempdb128801.31 MB127796.11 MB
[reserved][data][index_size][unused]
6984 KB3632 KB1576 KB1776 KB
Judging by these results, I should be able to reduce the data file size.
How can I confirm which internal processes are holding on to the TempDB space?