SQL Server: are temp tables stored in RAM or on disk?

Viewed 5476

I'm inserting over 10 million rows into a temp table and its size is about 5GB. My computer has 32GB of RAM. Does SQL Server put this table in RAM or on the disk?

0 Answers
Related