3 ms·
That's valid, but you want to keep in mind that SQL Server has ONE tempdb that is used across all databases. TempDB is used for temp tables, but TempDB is used
by chris_wot 11y ago
That's valid, but you want to keep in mind that SQL Server has ONE tempdb that is used across all databases. TempDB is used for temp tables, but TempDB is used for a raft of other features (like snapshot isolation). You need to ensure you don't start getting tempdb contention.