3 ms·
Using SQL Server my normal pattern of development is to do what I need using CTE's (WITH) and then switch to temp tables if/when the queries start to show poor
by johnnyb9 11y ago
Using SQL Server my normal pattern of development is to do what I need using CTE's (WITH) and then switch to temp tables if/when the queries start to show poor performance.
- chris_wot 11y agoThat'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.