Erik Darling walks through something that can slow down your temp table loads. The video covers a scenario in which a user creates a temp table, loads some data from it, and also wants to include an identity integer. Erik shows how this can lead to sub-optimal performance, as well as one alternative if you really do need a monotonically increasing value on your temp table.