Скачать или смотреть SQL Server Gotcha: Cached Temp Tables & Suboptimal Plans (Hebrew edition)

A while ago, I published a video explaining how SQL Server handles temporary tables inside stored procedures. Instead of dropping and recreating the temp table on each execution, SQL Server may cache the table and reuse it in subsequent runs.
You can watch that original video here:    • Temporary tables and statistics behind the...  
While caching can improve performance, it also introduces a subtle bug: cached temp tables may retain stale statistics from previous executions, which can lead to suboptimal query plans.
In this follow-up video, I’ll dive deeper into:
Why this bug often goes unnoticed
When it does impact performance
A demo showing a real case of a suboptimal query plan
Two practical demos with different solutions to fix the issue
A final discussion comparing the pros and cons of each approach
If you're working with stored procedures and temp tables in SQL Server, this video will help you avoid hidden performance pitfalls and write more reliable code.

The demo for this video can be downloaded from - https://drive.google.com/file/d/1X9c-...

00:00 Introduction
01:50 Why most times we won't notice a bad query plans, but sometimes we will?
04:10 Demo that shows the problem
08:09 Show that this is not due to parameters sniffing
09:42 First way to fix the problem
11:40 Second way to fix the problem
12:44 Discussion on which way should be used