Why would using a temp table cause a stored procedure to slow down dramatically and use massively more logical reads, compared to a permanent table?
In this course…
- Watch a demo of weird temp table performance problem in SQL Server
- See how to measure the problem
- Try your hand at figuring out ways to speed up the temp table
- Then watch me explore the issue and see a couple of possible workarounds to make that temp table faster.
The problem shown in this course applies to SQL Server 2005+. The demo code has been written and tested against SQL Server 2016 and SQL Server 2017 CU1.
Course scripts
https://github.com/LitKnd/SQLWorkbooks/tree/main/case_of_the_slow_temp_table
Each video has closed captions in English. A written transcript is included with each lesson.