sql-table-variable-deferred-compilation-in-sql-server-2019 
SQL Shack
NOVEMBER 25, 2019
In an article, An overview of the SQL table variable, we explored the usage of SQL table variables in SQL Server in comparison with a temporary table. The table […].
SQL Performance
OCTOBER 7, 2020
The canonical example of a plan operator that can rewind is the lazy Table Spool. The documentation says only the following operators can rewind: Table Spool. Table-valued Function. Table-valued functions use a table variable, which can be used to cache and replay results in suitable circumstances.
Expert insights. Personalized for you.
87 
Let's personalize your content