The Case of the Slow Temp Table: A Performance Tuning Problem (50 minutes)
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.
Each video has closed captions in English. A written transcript is included with each lesson.