![What's New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues) - Brent Ozar Unlimited® What's New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues) - Brent Ozar Unlimited®](https://www.brentozar.com/wp-content/uploads/2018/05/sql_server_2018_with_table_variable.png)
What's New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues) - Brent Ozar Unlimited®
![sql server - Why is table variable forcing an index scan while temp table uses seek and bookmark lookup? - Database Administrators Stack Exchange sql server - Why is table variable forcing an index scan while temp table uses seek and bookmark lookup? - Database Administrators Stack Exchange](https://i.stack.imgur.com/EKl5r.png)
sql server - Why is table variable forcing an index scan while temp table uses seek and bookmark lookup? - Database Administrators Stack Exchange
![sql server - Why is table variable forcing an index scan while temp table uses seek and bookmark lookup? - Database Administrators Stack Exchange sql server - Why is table variable forcing an index scan while temp table uses seek and bookmark lookup? - Database Administrators Stack Exchange](https://i.stack.imgur.com/QZb5p.png)