Scripts, Articles, Relevant for DBAs, Consultants, BI, Data Scientists and Developers
This article shows how we can enhance the performance splitting it up in multiples files
Further:
https://www.sqlvideo.com/AllVideos/Tempdb-Metadata-Contention---Table-Variable-Vs-Temporary-Table
Tempdb