mysql - Does MS-SQL support in-memory tables? - Stack Overflow

mysql - Does MS-SQL support in-memory tables? - Stack Overflow

瀏覽:1134
日期:2024-05-14
@Keith This is a common misconception: Table variables are NOT necessarily stored in memory. In fact SQL Server decides whether to keep the variable in memory or to spill it to TempDB. There is no reliable way (at least in SQL Server 2005) to ensure that ...看更多